Hi! I'm trying to replace any oc

[leassaf]

Hi!

I'm trying to replace any occurence of the symbol ; in the values of certain field. Is it possible through an SQL???

Assaf

 

[MichaelRed]

Depends on the db. ASSUMING Ms. Access

In an UPDATE query, Update to

Replace(FieldName. ";", "&quot

Just deletes the ";". If you want something else in it's place;

Replace(FieldName. ";", "Char(s)&quot





MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[leassaf]

When trying this, I got error messages. I'm not sure that the replace function is supported in msAcceess SQL. could you be more specific with the syntax?

Assaf

 

[MichaelRed]

Replace(String to Search, Char To Find, Replacement Char)

MyString = "This is the String To Search"
? Replace(MyString, " ", ";&quot
This;is;the;String;To;Search

In an UPDATE query, Update to (this is the ROW in the Query grid. "Replace is NOT an SQL function, but a VB / VBA function. I'm not positive it is in all versions. Try the example in the "immediate" / debug window. Just cut and paste the two lines, MyString = ... and ? Replace. If it gives an error something is awry. If it returns the same as my example it should work.





MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over