SQL - Find substring in char string

Going to Cali · 29 Jan 2008 at 22:23

Say i have a string

str = 'abcdefghij.......z',

Is there a function that, given a substring of str (such as 'abc') , would return all of a?

Sorry if it's a stupid question, I cannot find anything on google.

mark66 · 29 Jan 2008 at 22:37

I think you are looking for LIKE:

SELECT STR
FROM FILE_A
WHERE STR LIKE '%abc%'

This will return all STR strings from your file that contain abc anywhere in the field. If you only want those beginning with abc use 'abc%'.

mark66 · 29 Jan 2008 at 22:38

Just did a quick Google search on SQL LIKE and found this useful looking SQL site:

http://www.sql-tutorial.net/SQL-LIKE.asp

Going to Cali · 29 Jan 2008 at 22:43

Thanks a lot, very useful.