Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

sql query / procedure

Home
Forums

sql query / procedure

Vijayabhaskar Dabbara

12yAsked Aug 29, 2014, 8:45 AM1.3k

Hi Expert

In my data one column is like this way

id-varchar(10)

a4563457

g5678456

d3456278

bjhh7898

678gjkl8

.....as like in this type of data i want only 1st character in a-z/A-Z, other 7 should be integers

how could i validate this one, separate this kind of data . give me solution

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Ramesh Maruthi12y ago
SELECT * FROM TABLE
WHERE id LIKE '%[^a-zA-Z0-9]%'

or

select * from table
where regexp_like(id , '^\d+\D+$');