SQL Querry

pauledwardian:

Is there only 1 column in the table?  Does the row already exist?

AielloJ

by the way, do you guys know how can I replace comma in access with -in a particualr column? Like an access querry?

In Access VBA, if we're talking a string value, then use replace:

Dim str As String
str = "123,456"

MsgBox Replace(str, ",", "-")

Select allOpen in new window

If something else, let us know.

Still need some more details from you (AielloJ's comment), whether you are creating new records (INSERT) or changing existing records (UPDATE).

Perhaps you can provide us with what you have and what you want to help clarify what it is you're trying to accomplish.

Topics: MS SQL Server, Databases Miscellaneous, SQL Server 2008
Since you are using an MS Access database you should request that the MS SQL Server and SQL Server 2008 topics be replaced with the more appropriate MS Access topic.

this is my question:

https://www.experts-exchange.com/questions/27831971/Access-replace-comma-with-dash.html

Thanks!