How to Pull 1 word from a phrase in a table?

[Greasy]

i need to be able to pull everything with the word Belcher from DEPO @ 1875
N. BELCHER, DEPO @1875 N. BELCHER STE. 102, etc... basically anything with the
word Belcher in it i need to display from this table. do i do this in a query
or in the output?

and how do i do it?

[_andyK]

I found a great tag that can accomplish exactly what you want.

[url]http://www.contentbox.com/claude/customtags/tagstore.cfm[/url]

The tag cf_REextract works great. At $15 you can not go wrong.

[Greasy]

well is there a way to do it manually instead of paying.. im trying to do this on the free basis lol.

[arniebld]

what database are you using?

[CF_fdk]

By using substr and instr functions (Oracle) you'll manage to get the wanted result. Most databases have similar functions

[Greasy]

I am using SQLServer

[cjeris]

For SQL Server, perhaps you just want
SELECT {your-list-of-columns}
FROM {your-table}
WHERE {your-search-column} LIKE '%belcher%'
?

I don't think you can use LIKE on columns of type (N)TEXT though, only
(N)(VAR)CHAR.

[Greasy]

Thanks that did the trick.