Smith, thanks for the response, its and idea but i have 104 columns and 32 tables

user might select from any of those columns so its not that easy to...

we do have that issue, if it does not satisfy the realtion ship we have to move them to the error tables,

so my idea is to write the separate queries...

yep that worked Gianluca

Thanks everyone for your response

i have to select a column from a table which has all these 80 words so i am planning to write this using LIke.

please suggest me if you any...

i am inserting the data through SSIS but my crazy lead whats me do to the data scrubbing which has to check wehter that particualr text column has either HTML...

one record in our Notes column is like this

Notes:

nasal congestion pollen xyz valley/desire loss wt/>exercise <dietary intake

so i think the HTML which u gave me is replacing ...

Hi Thanks for the prompt response,your scripts are helpful

but we are not aware what kind of HTML tags and the sqlscripts they might send us as we are...