how to split a data from database based on character
- by udaya
Hi
I have a data april/2010 to jan/2011
Is there any way to split the data with character to
and select the date as
The value before "to" as FROM
and The Value after "to" as TO
how to selet the splited value......... while i am selecting the data as it is as
select date from mytbl
how to select the date as two values