SQL Concatenation (||), Query builder in VS 2005

Hi,
I need concatenate values of two fields in select command, but if I use this
select command in Query builder in VS I get error. I concatenate two string
values using SQL concatenation operator (||). It's a bug in Query builder? I
think....

William
Sat Jan 20 12:55:21 CST 2007

SQL Server's string concatenation symbol is + not ||.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Jirí Neuzil" <meuzil@seznam.cz> wrote in message
news:018DDAC3-7A24-4392-B19D-755A0BC279F2@microsoft.com...
> Hi,
> I need concatenate values of two fields in select command, but if I use
> this select command in Query builder in VS I get error. I concatenate two
> string values using SQL concatenation operator (||). It's a bug in Query
> builder? I think....

Jiøí
Mon Jan 22 03:52:41 CST 2007

Hi, but I use Firebird DB and standard operator for concatenation is
||....so it's a bug....


"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> pí¹e v diskusním
pøíspìvku news:eowIKSMPHHA.324@TK2MSFTNGP06.phx.gbl...
> SQL Server's string concatenation symbol is + not ||.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "Jirí Neuzil" <meuzil@seznam.cz> wrote in message
> news:018DDAC3-7A24-4392-B19D-755A0BC279F2@microsoft.com...
>> Hi,
>> I need concatenate values of two fields in select command, but if I use
>> this select command in Query builder in VS I get error. I concatenate two
>> string values using SQL concatenation operator (||). It's a bug in Query
>> builder? I think....
>
>