OK, so you have atomic data in your database, i.e. FirstName and LastName. My question relates to math operations and concatenations IN the SQL STRING to determine a condition.
I tried this, it doesn't work:
select * from addresses where FirstName & LastName = 'John Smith' ...doesn't work.
If I create a column called SpaceColumn which houses a default space ' ' character and go:
select * from addresses where FirstName & SpaceColumn & LastName = 'John Smith'
Tried + instead of &, doesn't fail but it doesn't find John Smith.
However, I tried NumberField1 + NumberField2 = '999' (any #) and that works.
Somebody out there has been through this and can offer some help. Bottom line is, how much can SQL do with operations on the field values while live in the query? Knowing will cut down on PHP scripting.
Sam Fullman
Compass Point Media
