Query XML in a database table

Hi,
I need to query a column in a database containing XML, I would like to delete all rows that do not contain the word Receipt in the XML?
could someone help with this please?

Regards,
Atorex
atorexAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
plusone3055Connect With a Mentor Commented:
DELETE FROM <your table>
WHERE <your column>   NOT LIKE '%receipt%'
0
 
plusone3055Commented:
DELETE FROM <your table>
WHERE <your column>   NOT LIKE '%receipt%'
0
 
atorexAuthor Commented:
thanks, I used the not like but did not use the %, knowledge is a beautiful thing!

thanks.
0
 
plusone3055Commented:
no problem have a great day
0
All Courses

From novice to tech pro — start learning today.