Is Valentina SQL able to concatenate?

[Barry G. Sumpter]

SELECT CONCAT('Va', 'len', 'tina');
=> 'Valentina'
SELECT CONCAT(Va', NULL, 'na');
=> NULL
SELECT CONCAT(14.3);
=> '14.3'

These special characters of open single quote and closed single quote aren't
recognized by my valentina sql db either.




-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Barry G. Sumpter
Sent: Saturday, 14 July 2007 6:29 PM
To: 'Valentina Developers'
Subject: RE: Is Valentina SQL able to concatenate?

Doh!

It's the ' single quote delimiters instead of the " double quote delimiters.

I hate it when that happens!



-----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:45 PM
To: Valentina Developers
Subject: Re: Is Valentina SQL able to concatenate?

Hi Barry,

On 2007-07-14, at 09:35, Barry G. Sumpter wrote:

> 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

I didn't get you, IMHO a quick check in VStudio was faster then  
writing your email, but "of course" I did it for you and for me

select concat(firstname,', ',lastname	) from oc_contact

runs w/o any issues, so yes, your querry should work, too.

regards

Thorsten Hohage
--
objectmanufactur.com - Hamburg,Germany


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

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