Re: Embed a string in a string

From: <gareth_at_jamms.org>
Date: Mon, 8 Jun 2009 08:25:00 -0700 (PDT)
Message-ID: <09b2ef2a-a556-4bc7-9a42-7250866fc83d_at_n19g2000vba.googlegroups.com>

On 8 June, 12:02, martinamul..._at_yahoo.ie wrote:
> Hi,
>
> I have a stored procedure that builds a query string as it goes
> through its code.  So I pass in a where statement as a long string
> with a few criteria in it.  Then I build some temporary tables and
> build other parts of the where statement as I go along.
>
> At one point I need to build a few AND statements but one of them
> contains a comparison of a string.  Can someone tell me please how I
> embed a string within a string in sql.  A small piece of very
> simplified code is below.  The word MEZZ should be in quotation
> marks.  Can anyone tell me how I can get it into quotation marks?  The
> error I’m getting at the moment is “Invalid column name 'MEZZ'”.
>
> declare _at_WarehouseSQL   nvarchar(100)
>
> select _at_WarehouseSQL =  ' select distinct rqpropno
> from vi_MAItems where val_lvl <>  MEZZ '
>
> exec(_at_WarehouseSQL)
>
> All help welcome
>
> LL

SELECT CHR(39)||'MEZZ'||CHR(39) FROM DUAL; HTH -g Received on Mon Jun 08 2009 - 10:25:00 CDT