Use the Instr function in combination with the Left$ function
Instr(1,"123/456","/") returns 4, which is the chanacter position of the "/"
So, Update TableName Set FirstPart = left$(Data,InStr(1,Data,"/")-1)
will update the column FirstPart in table Tablename with everything before the first /
Matt
Carolyn Bergin wrote:
Hi guys
I have a dataset that contains a field with references like 1/375 and 2/540 etc. I need to update another column with the just number preceeding the /. Is there any way I can do this using an SQL. The dataset is huge and im trying to save some time rather than going through and manually updating them all.
Thanks in advance
Carolyn
Carolyn Bergin
GIS Officer Planning and Strategy
email - [EMAIL PROTECTED]
phone - 9976 1593
fax - 9976 1400
-- Matt Bolton
Mach 3 IT Mobile 0412 122 416
Email [EMAIL PROTECTED]
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9475