Re: [SQL] SQL substring

[Franco Bruno Borghesi]

... WHERE field1 LIKE '%' || field2 || '%'
or
... WHERE position(field2 in field1)>0

On Wed, 2003-11-12 at 11:07, Guy Korland wrote:

Hi,
How can I compare two fields if one is a substring of the other?
Something like: 
	... WHERE StringA like '%' + StringB + '%';

Thanks,
Guy Korland


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

signature.asc
Description: This is a digitally signed message part