Hello i am having a problem right now, i don't know if it is even possible to do in SQL,
i have a table that contains contacts this table for simplicity of example has 2 columns ID and XMLdata in the XMLdata column there is xml data for example: "<some long="" sutff="">.....name>john<last name="">doesomething more>...
how can i search for name or last name of the column for XMLdata?
cause i can't use something like SELECT * FROM Contacts WHERE XMLdata LIKE '<name>%john%', and i need somethjing like that
is this possible to do?