SQL syntax question

[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....

 

[W.G. Ryan - MVP]

+ should work, FirstField + SecondField but depending on the type, you may
need to cast it to a Varchar or respective type.

 

[Guest]

VB Programmer,

SELECT MyPhone + '-' + MyCity AS MyInfo ...

Kerry Moorman

 

[VB Programmer]

Thanks y'all!

VB Programmer,

SELECT MyPhone + '-' + MyCity AS MyInfo ...

Kerry Moorman

 

[Cor Ligthert [MVP]]

VB Programmer

What should be the result from MyInfo?

Cor

 

[Cor Ligthert [MVP]]

Forget this one, I misreaded something.

Cor