Is Valentina SQL able to concatenate?

[Barry G. Sumpter]

I think that's a hard coded parameter function call not a SQL Concatination.

I'm looking for something like this:

SELECT 
CONCAT(tblShops.fldShopNo, " - ", blShops.fldShopName) as ShopName
FROM tblShops



-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Thorsten Hohage
Sent: Saturday, 14 July 2007 5:00 PM
To: Valentina Developers
Subject: Re: Is Valentina SQL able to concatenate?

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


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina