how to use CONCAT and WHERE statement in the same query

[userpien]

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!

[#2]

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.