On Thu, Feb 17, 2011 at 01:55:46PM -0500, akp geek wrote:
> Hi all -
>
> I am trying to write a query to find all the column names in
> database that has a underscore in it (_) example souce_id. I know like will
> not work , if where column_name like '%_%' Can you please help?
where col
that's right. Thanks again all for the help
On Thu, Feb 17, 2011 at 2:09 PM, David Kerr wrote:
> On Thu, Feb 17, 2011 at 01:55:46PM -0500, akp geek wrote:
> - Hi all -
> -
> - I am trying to write a query to find all the column names in
> - database that has a underscore in it (_) exam
On Thu, Feb 17, 2011 at 01:55:46PM -0500, akp geek wrote:
- Hi all -
-
- I am trying to write a query to find all the column names in
- database that has a underscore in it (_) example souce_id. I know like will
- not work , if where column_name like '%_%' Can you please help?
-
- Regar
Try just using the string function "position". You'll need to check the
documentation or wait for others to determine which specific system views
you will need to obtain the column name (if you do not already know that
part).
position(substring in string) int
Non-Zero (or maybe >= 0) indic
thanks . It worked
Regards
On Thu, Feb 17, 2011 at 2:05 PM, Radosław Smogura
wrote:
> akp geek Thursday 17 February 2011 19:55:46
> > Hi all -
> >
> > I am trying to write a query to find all the column names in
> > database that has a underscore in it (_) example souce_id. I know lik
akp geek Thursday 17 February 2011 19:55:46
> Hi all -
>
> I am trying to write a query to find all the column names in
> database that has a underscore in it (_) example souce_id. I know like will
> not work , if where column_name like '%_%' Can you please help?
>
> Regards
Try SELECT
