Re: subset of tables

From: Dave <x_at_x.com>
Date: Mon, 28 Mar 2005 22:11:23 GMT
Message-ID: <fi%1e.7414$Ab.6180@text.news.blueyonder.co.uk>

"ew1" <ewanski_at_email.arizona.edu> wrote in message news:1112045462.883971.252540_at_f14g2000cwb.googlegroups.com...
> Thanks!
> I did a
> show tables like 'z%'
> but it gave me an error of
> SQL-I-DEPR-FEATURE, Deprecated Feature: Keyword LIKE used as an
> identifier.
> Thanks for the hint!
>

ok, first one free

select table_name from tabs where table_name like 'Z%';

next time look in the docs :-) Received on Mon Mar 28 2005 - 16:11:23 CST