ADSM-L

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%'