1
Answer

any website for open source dotnet projects in asp.net mvc?

Pintu Master

Pintu Master

8y
261
1
any website for open source dotnet projects in asp.net mvc?
Answers (1)
0
ketan borsdiya

ketan borsdiya

NA 1.5k 3k 8y
Hi Gagan,
Write Below Query,
SELECT *
FROM <Your Table Name>
WHERE Name LIKE '14th-Copy%' and LEN(Name)<13;
Now accept my answer and enjoy :)
0
Manas Mohapatra

Manas Mohapatra

NA 29.3k 3.3m 8y
Try like below:
SELECT Id
FROM test
WHERE (len(Name) - len(replace(Name,'Copy',''))) = 4
0
Gagan Gautam

Gagan Gautam

NA 132 6k 8y
HI Ketan,
this query not working correctly. It returns all records who have copy keyword
0
Gagan Gautam

Gagan Gautam

NA 132 6k 8y
Plz Reply ASAP
0
Gagan Gautam

Gagan Gautam

NA 132 6k 8y
<h4><a data-userid="manas1" href="http://www.c-sharpcorner.com/members/manas-mohapatra">Hi Manas Mohapatra</a></h4><div>I have already decsribed my recuirement in my question .please see it</div>
0
Gagan Gautam

Gagan Gautam

NA 132 6k 8y
These query are wrong because it returns all records who have copy string.this is not my recuirment .
I need only records which have only one copy string
Requried Output:
1.14th-copy(2)
2.14th-Copy
-1
ali tuncer

ali tuncer

NA 2.9k 108 8y

use SQL LIKE operator

Check this link :

http://www.w3schools.com/sql/sql_like.asp

-1
Rajeev Punhani

Rajeev Punhani

NA 4.7k 402.5k 8y

Hi Gagan,

Please try the following query.

  1. SELECT*
  2. FROMtest
  3. WHERENameLIKE'%copy%';