Is Valentina SQL able to concatenate?

[Barry G. Sumpter]

Hi all,

I'm trying to get Valentina to do some work for me:

SELECT T1.ShopNo, T1.ShopName & ", " & T1.ShopState as ShopName from T1

Does anyone know how to do this?

Thanks,
     Barry G. Sumpter