Shen
asked on
sql server select a string with a double quote part
I need to select a string that also contains double quote from an xml column.
The string looks like: PostNotes="2". I was using xml like '%PostNotes=""2"", but i doesn't work.
The string looks like: PostNotes="2". I was using xml like '%PostNotes=""2"", but i doesn't work.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, this worked - LIKE '%PostNotes="2"%'.
Just have one last criteria:
LIKE '%PostNames="test"% - i runs but it does not seems to be getting the actual data.
Just have one last criteria:
LIKE '%PostNames="test"% - i runs but it does not seems to be getting the actual data.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks,
ASKER