simple but not working!
I'm trying to replace the ' character in a string and it's not working and I don't know why: here's what I'm using
<%=Replace(strProductShort, "'", "''")%>
and here it is in situ:
the error message is:
The reason it appears is because there is a ' character in the string input in the database i.e adam's
Not sure how to fix it if the above is not working.