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 |
|
whorush
Starting Member
1 Post |
 Posted - 2002-06-20 : 13:12:08
|
| hey guysi need to change all the commas (,) in my entire table to semicolons (;). i'm using access and i heard about this replace function, and i heard that i could use it as a select query, then an update query and it didnt work. i figured that they dont work in access. then i looked around on the web some more and everyone said that the replace function is really a vb function. is that true? i really dont know vb, and since i'm using access i guess it would be more like vba anyway. so what would the syntax in access look like? i'm pretty confusedany help would be greatly appreciated,brad coleman |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-06-21 : 12:48:29
|
| Hey BradUnfortunately not many here are access gurus... heheBut this question has come up beforehttp://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=17040If this isn't enough,use the forum search for replace() or maybe just replace(Hopefully you'll be able to get the anwer from there.-----------------------Take my advice, I dare ya |
 |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
|
|
|
|
|
replace , with ;