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 |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2003-10-28 : 10:53:32
|
| Is there one?Brett8-) |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-10-28 : 12:38:32
|
| REPLACE() .... i know 2000 has it, not sure about earlier versions.From Access Help:Returns a string in which a specified substring has been replaced with another substring a specified number of times.SyntaxReplace(expression, find, replace[, start[, count[, compare]]])- Jeff |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-10-28 : 13:00:25
|
| 2k got it? Stuck supporting a group that built sh_t with 97...upgrade isn't feasible...Since 2k and 97 don't play nice together, I had to build a mirror client...guess I can uograde my machine now...did I mention I hate access recently (I really like it...but what a pain sometimes)AND what's with these data access pages?Can they be any more painful?Brett8-) |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-10-28 : 13:07:40
|
| You can write your own version of Replace and put it into a public sub in a module, then you can call it from an Access query. You can use the regular VB Replace function too. I don't think you can call your version "Replace" though, it may cause an infinite loop in the code. |
|
|
|
|
|
|
Access equivilant of REPLACE