Trim [message #350705] |
Fri, 26 September 2008 00:04  |
subbu_tce
Messages: 98 Registered: July 2007 Location: pune
|
Member |
|
|
Dear All,
I am getting input data like 2000.00 as varchar and i need to
change into 2000.Sometime i may get 2000.0.so anyway i need to change into 2000 only.Kindly suggests.
|
|
|
Re: Trim [message #350713 is a reply to message #350705] |
Fri, 26 September 2008 00:44  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
INSTR can give you the position of ".".
SUBSTR can give you a substring.
Other way: REGEXP_SUBSTR
Other way: TO_NUMBER followed by TO_CHAR
All these functions in SQL Reference
Regards
Michel
|
|
|