SQL syntax question

  • Thread starter Thread starter VB Programmer
  • Start date Start date
V

VB Programmer

In SQL how do you combine several fields AS 'xxxxx'.

This type of syntax doesn't work
SELECT MyPhone & "-" & MyCity AS 'MyInfo' FROM XXXXX WHERE....
 
+ should work, FirstField + SecondField but depending on the type, you may
need to cast it to a Varchar or respective type.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL syntax error in INSERT INTO statement 5
Text to columns and comma delimited text 5
Unicode problem: Can read, but not store Chinese characters in database! 4
Using if on ASPX-side instead of in code behind 5
Macro to extract few values from a cell 3
Somebody Please Help 3
Drop Down Menu - Data Selection Request 5
multiple nested gridviews 0

Back
Top