Remove data after comma 1

[humbleprogrammer]

Hello - I have a bunch of data that has a comma and I would like to replace the , and anything after it. For example..

Glendale Height, IL 60139

I want to update to just
Glendale Height

Can someone let me know how I can do this with Access?

http://www.gosmart4u.com/

 

[adalger]

WhatYouWant = left("Glendale Height, IL 60139",instr(1,"Glendale Height, IL 60139",",")-1)

TMTOWDI - it's not just for Perl any more

 

[humbleprogrammer]

That did the trick. Thanks Much!

http://www.gosmart4u.com/