Is Valentina SQL able to concatenate?

[Thorsten Hohage]

Hi,

On 2007-07-14, at 03:21, Barry G. Sumpter wrote:

> 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?

Yes and this time it's even plain simple to find it in the wiki

<http://www.valentina-db.com/dokuwiki/doku.php? 
id=paradigma:public:en:documentation:vsql:reference:expr:functions:strin 
g&s=string+functions>


regards

Thorsten Hohage
--
objectmanufactur.com - Hamburg,Germany