Re: How do I structure the where clause to select rows whose data contains spaces?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: MGFoster (me_at_privacy.com)
Date: 03/03/04 

Date: Wed, 03 Mar 2004 21:38:36 GMT

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It just may be that there aren't any data in the source table that
have values with spaces in them. Or, there may be more than one space
in the value, but it appears as if there is only one space. E.g.:
L<space>GM doesn't equal L<space><space>GM, but they can look alike:

   L GM L GM

especially in proportional font displays.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQEZQaoechKqOuFEgEQLu4gCgqIWVsCFBdRqp1l+Z1xWmPEPigwUAnRGr
gDoYPus032yV/q3Zrc8II6OP
=d0/h
-----END PGP SIGNATURE-----

Ken wrote:

> I am trying to execute this INSERT INTO statement, and it fails when I specify a column that includes a space, such as "L GM", however when the column data contains no spaces as in "LGM" the query executes fine:
>
> SELECT TargSrt.opt_symbol AS FirstOfopt_symbol, TargSrt.Ticker, TargSrt.imp_volat AS Hvolat, TargSrt.strike AS FirstOfstrike, TargSrt.exp_date AS FirstOfexp_date INTO Temp From TargSrt WHERE TargSrt.opt_symbol = 'L GM';
>
> the above statement simply doesnt insert anything into the TEMP table, whereas the following statement works fine (exactly same except for where clause):
>
> SELECT TargSrt.opt_symbol AS FirstOfopt_symbol, TargSrt.Ticker, TargSrt.imp_volat AS Hvolat, TargSrt.strike AS FirstOfstrike, TargSrt.exp_date AS FirstOfexp_date INTO Temp From TargSrt WHERE TargSrt.opt_symbol = 'ABCD';
>
> How do I structure the where clause to select rows whose data contains spaces?
>

Relevant Pages