embedded apostrophe 1

[grndpa]

In an earlier post, rac2 and PHV helped me with the SQL format example.

sqlOut = "INSERT INTO tryit (myID) VALUES ('" & aEMPLID & "')"

This worked fine until I got to aEMPLID valued O'Shane (i.e. apostrophe embedded in the name).

I do have a function through which I run my string input. It checks for a null value, the word "null" (due to uncleansed data from another system) among other machinations. Is there something I could code into this function to take care of my embedded apostrophe problem?

(I do have a workaround that involves substituting a dollar sign for the apostrophe before posting, and reversing it upon retrieval, but that strikes me as having a high "stink" factor)

Regards,

Grnadpa Brian

 

[PHV]

sqlOut = "INSERT INTO tryit (myID) VALUES ('" & Replace(aEMPLID, "'", "''") & "')"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[grndpa]

Thank you.

Can you recommend a microsoft SQL reference? I never would have figured these out based on my experience with other sql encounters (DB2, mySQL). And Wiley Publishing's Access 2003 Bible doesn't cover these kind of details.

Thanks again!

Grnadpa

 

[JA3395]

[blue]

http://msdn2.microsoft.com/en-us/library/aa139974(office.10).aspx

[/blue]

Is always the best place to start

Then

[blue]

http://www.devguru.com/technologies/jetsql/home.asp

[/blue]

use Google to search for SQL reference pages. There are a lot of them out there.

J.