Access Substring Command ?

[dhrehor]

Need to truncate a field. Here is what I have:

update PARTS set weight = substring(weight,1, charindex(' ',weight))

Original Field is : 5.36 lbs
Need to make it: 5.36

Need this done throughout the table PARTS.

Thanks

Don

 

[Golom]

The corresponding Access functions are Mid and Instr

update PARTS set weight = Mid(weight,1, Instr(weight," "))

 

[RoyVidar]

Using the Val function, could perhaps fit here (check it out in the help files), else a combination of InStr and Mid?

mid$(field,1, instr(field," ")-1)

Roy-Vidar