View previous topic :: View next topic
|
Author |
Message |
ravindra.vadali
New User
Joined: 30 Jan 2012 Posts: 34 Location: USA
|
|
|
|
Hi All,
Is there a way to write a table to select all the columns which have alphabets from A-Z
Example:
Sample table data:
Slno. Emp_Name Emp_id
1 RRR 101
2 SSS A12
3 TTT 102
4 XXX 2B3
5 YYY 103
6 ZZZ 3FF
So my result should be
2 SSS A12
4 XXX 2B3
6 ZZZ 3FF
I tried running the below query but it didn't fetch any result
SELECT * FROM EMP_TABLE WHERE EMP_ID LIKE '%[A-Z]%';
Could you please help me on this,
Also, Happy new year to everyone!! |
|
Back to top |
|
|
ravindra.vadali
New User
Joined: 30 Jan 2012 Posts: 34 Location: USA
|
|
|
|
Just to add more to my note, I can achieve it by using the below query but its more lengthy and confusing. It would be great if I could get a quicker and smaller query
Quote: |
SELECT * FROM EMP_TABLE WHERE
((EMP_ID LIKE '%A%') OR
(EMP_ID LIKE '%B%') OR
(EMP_ID LIKE '%C%') OR
(EMP_ID LIKE '%D%') OR
(EMP_ID LIKE '%E%') OR
(EMP_ID LIKE '%F%') OR
(EMP_ID LIKE '%G%') OR
(EMP_ID LIKE '%H%') OR
(EMP_ID LIKE '%I%') OR
(EMP_ID LIKE '%J%') OR
(EMP_ID LIKE '%K%') OR
(EMP_ID LIKE '%L%') OR
(EMP_ID LIKE '%M%') OR
(EMP_ID LIKE '%N%') OR
(EMP_ID LIKE '%O%') OR
(EMP_ID LIKE '%P%') OR
(EMP_ID LIKE '%Q%') OR
(EMP_ID LIKE '%R%') OR
(EMP_ID LIKE '%S%') OR
(EMP_ID LIKE '%T%') OR
(EMP_ID LIKE '%U%') OR
(EMP_ID LIKE '%V%') OR
(EMP_ID LIKE '%W%') OR
(EMP_ID LIKE '%X%') OR
(EMP_ID LIKE '%Y%') OR
(EMP_ID LIKE '%Z%')) |
|
|
Back to top |
|
|
saiprasadh
Active User
Joined: 20 Sep 2006 Posts: 154 Location: US
|
|
|
|
Ravi,
You can use TRANSLATE function in DB2.
Code: |
SELECT * FROM EMP_TABLE WHERE translate(EMP_ID , ' ','1234567890') <> ' ' ; |
|
|
Back to top |
|
|
ravindra.vadali
New User
Joined: 30 Jan 2012 Posts: 34 Location: USA
|
|
|
|
Thanks Sai,
This worked for me.
Happy New Year.
Regards,
Ravi |
|
Back to top |
|
|
|