Insert statement problem in sql server 2005

[avinashpatil]

Hi All
i have problem in insert statement in which one string returning me value as g's and because of that s is gets separated. and its giving me eroor as Incorrect syntax at s.

strSQL = "Insert into HeaderInfo(yAxisLabel , xAxisLabel , zAxisLabel , yAxisUnit , xAxisUnit , zAxisUnit)"
 strSQL &= " values('" & YAxisLabel & "','" & XAxisLabel & "','" & ZAxisLabel & "','" & YAxisUnit & "','" & XAxisUnit & "','" & ZAxisUnit & "') "

here YAxisUnit variable giving o/p as g's
so how to remove that problem
plz help me out from it

thanking you all

[Ramy Mahrous]

I don't understand your problem neither the error you got. Please clarify your question, copy the error message and tell us which language you use.