Re: SQL to search for column name
How about:
select Page_number_on_VERY_BASIC_SQL
from TFM
where attitude="can't be arsed to look it up"
and i_am_lazy = 'true'
and get_someone_else_to_do_my_work = 'easier than looking in a manualfor once'
??
Think that would work.
Even though I so ashamedly answered the question properly. I like this
answere much better. I was just to lazy to dream up a smart ass answer.
Is there a FM where I could look those up? B-)
--- theusarools@hotmail.co.uk wrote:
> How about:
>
> select Page_number_on_VERY_BASIC_SQL
> from TFM
> where attitude="can't be arsed to look it up"
> and i_am_lazy = 'true'
> and get_someone_else_to_do_my_work = 'easier than looking in a manual> for once'
>
> ??
>
> Think that would work.
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
<div id="RTEContent">DL Redden <br> <br>Visit my wifes web site <a href="http://www.lishalynn.com">www.lishalynn.com</a>; for all of your makeup and skin care needs.</div>
>Even though I so ashamedly answered the question properly.
Well you almost got it right.
>>get a list of any column that contains "vendor"
which would look like
select a.tabname, b.colname
from systables a, syscolumns b
where a.tabid = b.tabid and b.colname like '%vendor%'