|
View previous topic :: View next topic
|
| Author |
Message |
rajkumarmf1985
New User
Joined: 09 Aug 2010
Posts: 18
Location: bangalore
|
|
|
|
HI ,
I have to fetch the rows which contains the values like below.
RAJ KUMAR = there is one space between RAJ and KUMAR.
usually values will be like this. Now i have to fetch the rows which contains more than one space between the values in VARCHAR field column like below.
RAJA ##### VENKAT (# = space)
Can anyone please suggest how to get this...?
Thanks in Advance,
Raj kumar |
|
| Back to top |
|
 |
chandan.inst
Active User
Joined: 03 Nov 2005
Posts: 275
Location: Mumbai
|
|
|
|
Hi,
Try below sql
| Code: |
SELECT * FROM
TABLE NAME
WHERE LOCATE(' ',RTRIM(COLUMN-NAME)) > 0 |
First string in locate function is Twp Spaces as you need more than one space in column
Regards,
Chandan |
|
| Back to top |
|
|
rajkumarmf1985
New User
Joined: 09 Aug 2010
Posts: 18
Location: bangalore
|
|
|
|
| Thanks ..chandan It's working fine. |
|
| Back to top |
|
|
|
|
