Peter H. Coffin <hellsop@ninehells.com> wrote:


> "*" is not a LIKE wildcard. "%" and "_" are LIKE wildcards.
>

my query is:
rs.open "select artista, substring(artista, locate(artista, ' ') as
surname , online from artisti where online = 'S' having surname like
'W%' order by surname asc" , conn

but "Andy Warhold" is in the database in the ARTISTA field.
where's the problem?
thanks, Ale.