RE: Returning a word from a field in a table 1

[allyne]

I have a sql table that contains a field as a varchar (2000). I need to pull a word from that field if it exists. For example:

Table/field name is note.text. If the note.text field contains the word 'Education' (this word can be anywhere with the text)then return the word 'Education'

Thanks for your help.

 

[bborissov]

SELECT 'Education' AS SomeField
FROM TableName
WHERE CHARINDEX('Education', SomeField) > 0

NOT TESTED!!!

Borislav Borissov
VFP9 SP2, SQL Server

 

[allyne]

Works great! Thanks so much!

 

[Andrzejek]

Or...

SELECT 'Education' AS SomeField
FROM TableName
WHERE NoteTextField LIKE '%Education%'

---- Andy

There is a great need for a sarcasm font.