SQL Query where left operator is contained in right operator?
Posted on 2004-08-30
In my CF application, I need to return results where a variable string contains the value of a Column.
If it was the opposite, it would be easy
e.g. SELECT * from Table WHERE ColumnA LIKE '#string#'
But I want to know if the left operator (table column) is within the right operator (variable string).
e.g. SELECT * from Table WHERE '#string#' LIKE ColumnA [can't do that, of course]
#string# will vary only in the last character which can be any number.
So if #string# can be foo1, foo2, foo59, etc. my ColumnA will contain "foo" indicating that
whenever the string contains "foo%" it will return the record. Is there a way to put a wildcard character
in the table column or is there another way to accomplish this.