Subject | Substring in SQL |
---|---|
Author | williamvdw2004 |
Post date | 2005-02-01T08:38:30Z |
Hi
I would like to extract records that contain certain words in varchar
fields e.g. I would like to filter messages that contain "bad" words.
I have tried substring but since the word could be any ware in the
message this is not exactly what I want.
Thanks in advance
William
I would like to extract records that contain certain words in varchar
fields e.g. I would like to filter messages that contain "bad" words.
I have tried substring but since the word could be any ware in the
message this is not exactly what I want.
Thanks in advance
William