Try something like this:
select appliestobuild + title as boo from change
Jared Clinton
Software Engineer
Maxi Multimedia
NEC Australia
> -----Original Message-----
> From: Ang�l Stewart [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 4 May 2001 5:49
> To: CF-Talk
> Subject: Combining two fields In Access SQL.
>
>
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
