On Fri, 18 Aug 2006 13:24:36 +0200, "Arjen" <boah***@hotmail.com>
wrote:

>Hi,
>
>I have a select statement (stored procedure) that selects on the first char.
>The first char is an input parameter.
>I.e. on my webpage I show the alphabet a ... z when a webuser select a char
>the selection will be based on this first char.
>
>Now I want to include in the weblist non a ... z chars as one item (like a
>0...9 button). But this are more than one chars.
>
>I don't know how to do this in an easy way? Now I have something like name =
>@char + '%'
>(The best is that is does not select records where the first char start with
>a ...z)
>
>Hope some ons knows a simple solution.
>Thanks!
>Arjen
>

"Roy Harvey" <roy_har***@snet.net> schreef in bericht
news:i6ebe2l4km3ng3e72q0n5bp91g8aa6e0pn@4ax.com...
>  LIKE '[^a-z]%'
>
> Roy Harvey
> Beacon Falls, CT
>
> On Fri, 18 Aug 2006 13:24:36 +0200, "Arjen" <boah***@hotmail.com>
> wrote:
>
>>Hi,
>>
>>I have a select statement (stored procedure) that selects on the first
>>char.
>>The first char is an input parameter.
>>I.e. on my webpage I show the alphabet a ... z when a webuser select a
>>char
>>the selection will be based on this first char.
>>
>>Now I want to include in the weblist non a ... z chars as one item (like a
>>0...9 button). But this are more than one chars.
>>
>>I don't know how to do this in an easy way? Now I have something like name
>>=
>>@char + '%'
>>(The best is that is does not select records where the first char start
>>with
>>a ...z)
>>
>>Hope some ons knows a simple solution.
>>Thanks!
>>Arjen
>>