I'm trying to figure out some SQL here and am wondering this:
Is it possible to select data based on a sub-string of a text field?
Say I have these values in a field called "ROOMS": |1|2|5|45|36|27|
And say the ROOMS field in any record will always be pipe-enclosed numeric
Is there any way for me to select records based on all ROOMS fields that
I have no idea what the proper (if possible) syntax would be, but here's my
SELECT * FROM TableName
WHERE the ROOMS field contains the string "|45|"
Any help would ...