Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
goksut
Starting Member
5 Posts |
 Posted - 2003-05-14 : 14:22:54
|
| I have a field in one of my tables like this one:Jane Eyre/IT/US/Americas. I would like to have only the name Jane Eyre showing up. So I probably will have to read it until slash and then replace the rest with blank. Does anybody have an idea how to this in Access? |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-05-14 : 16:07:21
|
| select left(Field, instr(1,Field, "/")-1)FROM yourtable- Jeff |
 |
|
|
|
|
|
String Search and Replace