August 18, 2006 at 9:08 am
Can someone tell me how to query a column in a table for a Substring. Or even a query that would query all of the tables at the same time would be nice.
For example, lets say I have a column with each data field containing at least 256 lines of text. What I want to do is to find a particular word in the 256 line of text.
So for example if I have a column named Travel, how do I search for a word like "Hawaii" ?
If someone could help me out with this, I would appreciate it.
August 21, 2006 at 8:00 am
This was removed by the editor as SPAM
August 21, 2006 at 9:55 am
This is all covered in BOL.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
August 21, 2006 at 3:53 pm
What is BOL ?
August 22, 2006 at 2:58 pm
I do worry sometimes !! Books On Line make sure you download the latest set from microsoft web site - seems they get monthly updates.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply