Jump to content


Photo

Order by pbm


  • Please log in to reply
1 reply to this topic

#1 shan_cool

shan_cool
  • Members
  • PipPipPip
  • Advanced Member
  • 53 posts
  • LocationChennai,India

Posted 07 June 2006 - 04:55 AM

Hi all,
I have a mysql field with following data:
TS_SAM_UA_1
TS_SAM_UA_5
TS_SAM_UA_2
TS_SAM_UA_11
TS_SAM_UA_10
TS_SAM_UA_14

I am Populationg all these values in a combo box...

my query is
Select (Emp_Id + 0) as int_id From HR_Emp_Det order by int_id
it displays as

TS_SAM_UA_1
TS_SAM_UA_10
TS_SAM_UA_11
TS_SAM_UA_14
TS_SAM_UA_2
TS_SAM_UA_5

but i need it as


TS_SAM_UA_1
TS_SAM_UA_2
TS_SAM_UA_5
TS_SAM_UA_10
TS_SAM_UA_11
TS_SAM_UA_14

Rgds,
shan


#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 09 June 2006 - 05:54 AM

The problem is that you can't cast these as numbers, since they're strings. You'd have to parse out the last part (from the last _ to the end) and then +0 just that component. If you know that each value has a similar format, you can probably rely on this, but it's not very robust. A combination of RIGHT() and LOCATE() shoudl work.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users