Combining two fields In Access SQL.

[Ang�l Stewart]

HI!

I want to select Lastname Firstname AS Name in an Access SQL query.

Select fname||lname AS name From Users,Vehicles
Where name = #searchname#

Doesn't work..
I get an error saying Invalid use of Pipe.
:-\
*sigh*

Any ideas on how to do this in Access?

-Gel


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists