special characters within a SQL 7 DB

Ok.. so you need something in a DB to be...

AT&T....

obviously this sometimes cause problems and sometimes not...

Do you just replace the & with it's ascii value... &

sometimes if i have to pull the db item such as 'AT&T Partner'
the page prints 'AT'

Or if i need 'Cabinets, KSU's & Something else' ...
I get 'Cabinets, KSU'

do I have to do a replace in and a replace out? the ' i can avoid all together.. but I'm not getting out of AT&T

There is no problem storing "AT&T" in a database column. Perhaps your program code is having a problem.

ya know what... . ur right...

When i pull from the DB, I get the full string..

but then i PASS IT THROUGH QUERYSTRING>>>>>>>

and that's where i run into the problem...
I request on the second page... and then try to dispplay it and it gets pissed..

sorry for the dumb question, but good idea to check..

What about storing the ' ?

To store a ' character in MS databases, you need to "double it up"

Function StrQuoteReplace(strValue)
StrQuoteReplace = Replace(strValue, "'", "''")
End Function

refine every data from the text field to be entered into your database using the above function

Please don't resurrect dead threads, no one has posted to this thread in 6 months.