0
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
HI Ketan,
this query not working correctly. It returns all records who have copy keyword
0
<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
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
-1
Hi Gagan,
Please try the following query.
- SELECT*
- FROMtest
- WHERENameLIKE'%copy%';