View previous topic :: View next topic
|
Author |
Message |
umed
New User
Joined: 13 May 2005 Posts: 38
|
|
|
|
Hi,
can we extract records from db2 table having values in a perticular column in lower case?
If yes what is the query used for it?
regards,
amol |
|
Back to top |
|
|
balu_ver2k5
New User
Joined: 17 Oct 2005 Posts: 2
|
|
|
|
Hi Umed
Example query
Select * from MASTER WHERE EMP_NAME=LCASE('UMED')
let me know if u cant understand |
|
Back to top |
|
|
swapnilverma
New User
Joined: 10 Oct 2005 Posts: 4 Location: bangalore,india
|
|
|
|
Quote: |
select ename from emp where upper(ename)=&ename;
or else
select ename from emp where ename=lower(&ename)
plz revert if its not work ......
Enjoy!!!! |
|
|
Back to top |
|
|
umed
New User
Joined: 13 May 2005 Posts: 38
|
|
|
|
Hi ,
Its not working. i m explaining the problen in details
suppose we have following table :
Name salary
------------ ----------------
amol 100
Umed 200
RAM 300
Mohan 400
Sham 200
JON 100
Here i need to extract following rows as they do not contain
all capital letters in Name column :
amol 100
Umed 200
Mohan 400
Sham 200
can we do this using a single Query.
We have to process thousands of such records.
regards,
Umed |
|
Back to top |
|
|
DavidatK
Active Member
Joined: 22 Nov 2005 Posts: 700 Location: Troy, Michigan USA
|
|
|
|
I?m sure you have already solved this, or no longer have the need.
SELECT NAME, SALARY
FROM EMP
WHERE NAME <> UCASE(NAME)
This should select any row where any character in name is not upper case |
|
Back to top |
|
|
|