Any yous guys know how to do dis?:
SELECT FirstName, LastName
FROM Names
WHERE LCase(FirstName) LIKE LCase(#Criteria#)
...meaning whether they search for "bob" or "Bob" I want to return
"Bob."
But this doesn't work... Error code says 'invalid column name'
Sos I thought maybe:
SELECT LCase(FirstName) as LowerCasedName, LastName
FROM Names
WHERE LowerCasedName LIKE LCase(#Criteria#)
...but that dont work neither...
tanks!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
