Replace * in a data field 2

[HEMASUR]

I need to replace an "*" that is in the middle of a field,

Field1
1106356*01
1344106987 01
1107661*01
1108210*01
5461108474*01
1108474*02
11208474*03
1108474*04
6789*05
18808581*01
1109097*01
1109541*01

Since the * appears in different places, I am not able to concatenate. Could some one please help me with this.
Thanks in advance

 

[PHV]

Replace(Field1, "*", "?")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[HEMASUR]

It did not work, since * denotes everything the whole field gets replaced with "?".

 

[PHV]

Really ?
not for me (ac2k3)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[HEMASUR]

Could you please let me know where you are using the command. I tried it as a simple find and replace and then again as a command function, and it still did not work.

 

[PHV]

Both in SQL and in VBA.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[HEMASUR]

Thanks a lot, it works, I appreciate all your help.