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.
Please post table design as DDL, some sample data as DML statement and the expected result.