Re: Question about using global characters in a select statement
2002-07-24 11:17:03
Subject: |
Re: Question about using global characters in a select statement |
From: |
Thomas Denier <Thomas.Denier AT MAIL.TJU DOT EDU> |
Date: |
Wed, 24 Jul 2002 11:18:29 -0400 |
> For example if I use something like:
>
> select node_name, filespace_name from filespaces where node_name='AD1%'
>
> to get information about all nodes whose node_names begin with 'AD1' I get
the
> following error:
>
> ANR2002E Missing closing quote character.
The correct form for the where clause is:
where node_name like 'AD1%'
|
|
|