Filter Query XML stored as String

• Steve Hindle-535638

  SSCrazy

  Points: 2378

  More actions

  April 30, 2008 at 3:08 am

  #69938

  Using SQL2000 I need to use an BinTypeID in a WHERE clause stored in a string field that contains XML.

  This is what I have inherited in the WHERE clause but is very slow:

  (pnx_request_formdata.form_data like '% %' OR

  pnx_request_formdata.form_data like '% %' OR

  pnx_request_formdata.form_data like '% %' OR

  pnx_request_formdata.form_data like '% %')

  Is there a neater way of doing this?

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  May 1, 2008 at 3:36 pm

  #809842

  Yes, there is.

  Parse XML, put data into relational database and do search from there.

  _____________
  Code for TallyGenerator