How to get the Column Name which does not contain underscore (_) in the column name

Tags:
SQL Columns
I need the list of column names which doest not contain underscore (_) in the column name.
For Ex:
Column List:
abc_Company
bcd
cde_Company
dec
Expected output:
bcd
dec
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Try using a select with the not like condition test,  looking for the underscore. That will give you the results.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Assuming this is an assignment or home work. Have you written some code or tried out? What software is there? What OS are you using? On which tool/ software that you want to do this task? Please do reveal more details with real scenario.
    137,090 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: