Forum Discussion
how to use CONCAT and WHERE statement in the same query
Hi, I need to write a query:
SELECT
TBVL.VLASC + ' - ' + .TBVL.DSVL
WHERE
TBVL.NMFI= 'ANAR' and TBVL.NMCA= 'TPGE'
AS columnName
how do i write this to sql server management studio?
Thank you!
- That's really to less on information and the syntax of your pseudo SQL is wrong.
Please post table design as DDL, some sample data as DML statement and the expected result.
