deepzzzz (7/16/2012)
[font="Arial"]Its showing both Application with IDs 3 & 4. I want exact match for apostrophe.[/font]
Little correction in Subbareddy code will work.
DECLARE @T1 TABLE(ID INT,NAME VARCHAR(30))
INSERT INTO @T1(ID,NAME)
SELECT 1,'AA'
UNION
SELECT 2,'BB'
UNION
SELECT 3,'"Application''s"'
UNION
SELECT 4,'"Application"'
SELECT * FROM @T1
WHERE NAME LIKE '"Application''s%'
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂