Re: Comparison

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Franck Diastein (fdiastein_at_euskaltel.net)
Date: 11/09/04 

Date: Tue, 09 Nov 2004 10:20:54 +0100

I'm now trying to normilize some data, and this sql statement doesn't work:

SET serial = REPLACE(PARTS, '+25 ','')

How can I replace +25 with the space with nothing ? I'm doing this from
SQL editor for a table in EM...

TIA

Anith Sen wrote:
> That would be correct. A simple example:
>
> SET ANSI_WARNINGS OFF
> DECLARE @v VARCHAR(20), @c CHAR(20), @nv NVARCHAR(20), @nc NCHAR(20)
>
> SELECT @v = 'ABC ', @c = 'ABC ', @nv = N'ABC ', @nc = N'ABC '
>
> SELECT LEN( @v ), LEN( @c ) ,
> LEN( @nv ) , LEN( @nc ),
> DATALENGTH( @v ), DATALENGTH( @c ) ,
> DATALENGTH( @nv ) , DATALENGTH( @nc )
>
> SELECT CASE WHEN @v = 'ABC' THEN 'Trims' ELSE 'No' END AS "vc",
> CASE WHEN @c = 'ABC' THEN 'Trims' ELSE 'No' END AS "c",
> CASE WHEN @nv = N'ABC' THEN 'Trims' ELSE 'No' END AS "nv",
> CASE WHEN @nc = N'ABC' THEN 'Trims' ELSE 'No' END AS "nc" ;
>

Relevant Pages

  • Running dynamoc SQL code
    ... I want to run an SQL statement that I have generated and ... to accomplish this, but nothing seems to be functioning. ... TIA, ...
    (microsoft.public.sqlserver.programming)
  • select into overwrite table
    ... how can i automatically overwrite an exisitng table when i execute a select ... into make table sql statement? ...
    (microsoft.public.access.gettingstarted)
  • Select sum() query
    ... A RunSQL action requires an argument consisting of an SQL statement. ... what am I missing here? ...
    (microsoft.public.access.modulesdaovba)
  • When a valid SQL doesnt make a valid Local View
    ... I have a SQL statement that works fine. ... Column 'ENTRYKEY' is not found. ... Weird, huh? ... TIA, ...
    (microsoft.public.fox.programmer.exchange)