trimming a field of type varchar

[srinivas Guduru]

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

[chulett]

Use the Field() function to take the first field from a space delimited string.

[srinivas Guduru]

Use the Field() function to take the first field from a space delimited string.

The length of the field may vary , because originally field type and length is varchar 254.

can you give me the function syntax

thanks

Srini

[vinothkumar]

Field(columnname,' ',1)