Re: SQL Query

From: <michael_bialik_at_my-deja.com>
Date: Sat, 26 Feb 2000 14:44:31 GMT
Message-ID: <898ose$htl$1@nnrp1.deja.com>

Hi.

You are correct unless there is a space involved e.g. '9 8'.

Michael.

In article <8943it$8pf$1_at_nnrp1.deja.com>, joe_celko_at_my-deja.com wrote:
>
> >>Is there a way to select all fields which have an alphabetical sign
> in it? <<
>
> LOWER (mystring) <> UPPER(mystring)
>
> --CELKO--
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Feb 26 2000 - 08:44:31 CST