Hi
I have a field (column) of type varchar and values like below
$60000 cash
$3835.50 MRY SINGLE.
I want to populate like below
$6000
$3835.50
can any one suggest me the solution
Thanks
Srini
trimming a field of type varchar
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 38
- Joined: Sat Dec 29, 2007 9:58 am
-
- Premium Member
- Posts: 38
- Joined: Sat Dec 29, 2007 9:58 am
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India