Need help with 'contains' in fulltext search

hello Forum,

I have a table which holds large amount of sql statements - 1 per column, row.

I need to find rows which contain schema name 'code'.

So i am looking for strings ' code.' or ' code].'

How would I construct the contains clause?

I tried below - it produces wrong results. 

where

contains(sql_text, 'code..')
May 20th, 2015 4:43pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics