Code Forums - View Single Post

aliaga61 · 10-18-2007, 08:56 AM

i have a value from a database field which is formatted as 123-45. I want to take 123 and assign it to variable a, and 45 and assign it to variable b, but I can't find what I need to do this. can i use the ltrim and rtrim functions? the problem is that the values left and right of the '-' can vary in length.

10-18-2007, 08:56 AM	#1 (permalink)
aliaga61 Recruit Join Date: Oct 2007 Posts: 2	pl/sql truncating string after character i have a value from a database field which is formatted as 123-45. I want to take 123 and assign it to variable a, and 45 and assign it to variable b, but I can't find what I need to do this. can i use the ltrim and rtrim functions? the problem is that the values left and right of the '-' can vary in length.