Posted by COHENMARVIN on 10/20/05 22:19

The following sql statement fails:
SELECT IdFlight, OrganizerLastName + ", " + OrganizerFirstName + "
Flt:" + FlightNumber As Concat FROM TableFlights Order By
OrganizerLastName, OrganizerFirstName
I'm trying to concatenate fields and words, but my asp.net page gives
me an error saying " Flt:" is not a field.
Thanks,
Marvin

• Next in forum: Re: Table Documentor
• Prev in forum: Re: Table Documentor
• Thread view: How do I concatenate text to a sql statement

[Reply to this message]