Concatenation is like this:
select fname+' '+lname as name
But you're using name in the where clause. Is it a field? If so, select name.
If not, modify your where clause.
Also, you're not joining the Users and Vehicles tables.
-David
On Thursday, May 03, 2001 12:49 PM, Angel Stewart [SMTP:[EMAIL PROTECTED]]
wrote:
> 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?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
