i want to get only those records who have only like this

Hi Gagan,

Write Below Query,

SELECT *

FROM

WHERE Name LIKE '14th-Copy%' and LEN(Name)<13;

Now accept my answer and enjoy :)

0

Try like below:

SELECT Id

FROM test

WHERE (len(Name) - len(replace(Name,'Copy',''))) = 4

0

HI Ketan,

this query not working correctly. It returns all records who have copy keyword

0

Plz Reply ASAP

0

I have already decsribed my recuirement in my question .please see it

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

0

use SQL LIKE operator

Check this link :

-1

Hi Gagan,

Please try the following query.

-1