Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
How do I concatenate text to a sql statementThe 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
Post Follow-up to this message
Re: How do I concatenate text to a sql statementSQL delimits string literals with single quotes rather than double: SELECT IdFlight, OrganizerLastName + ', ' + OrganizerFirstName + 'Flt:' + FlightNumber AS Concat FROM TableFlights ORDER BY OrganizerLastName, OrganizerFirstName ; -- David Portas SQL Server MVP -- "COHENMARVIN" <cohenmarvin@hotmail.com> wrote in message news:1129835952.069950.284810@z14g2000cwz.googlegroups.com... > 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 >
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
