Is Valentina SQL able to concatenate?

[Thorsten Hohage]

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