J
JoHickey
I need to replace everything past a specific character "~" with nothing. For
example:
West Elgin~West Elgin~West Elgin
Hamilton~Hamilton
Guelph~Guelph~Guelph~Guelph
I would like to have the query return only the information up to but not
including the first ~. The problem is that the number of characters is not
the same on all records, therefore using Left or Replace isn't working.
Any help would be appreciated. Thanks.
example:
West Elgin~West Elgin~West Elgin
Hamilton~Hamilton
Guelph~Guelph~Guelph~Guelph
I would like to have the query return only the information up to but not
including the first ~. The problem is that the number of characters is not
the same on all records, therefore using Left or Replace isn't working.
Any help would be appreciated. Thanks.