Hi Chris,

Using XML to post data from ASP pages to SQL database. A function in a schema to encrypt special characters in a URL did not so for % (pure...

Thanks very much, pointed me in the right direction.

The ASCII value of the bad character was 0.

So I was able to locate records containing the offending character using

select * from...

oops...dropped a bracket!

CREATE TABLE #FeatureLevels (

       FeatureID            smallint NOT NULL DEFAULT 0,

       UserLevel            varchar(50) NOT NULL

                                   CHECK (Userlevel in ('Guest','User','Administrator')),

       [Desc]                 varchar(255) NULL

)

I copied your code in SQL-QA and it works for a temp table with

CREATE TABLE #FeatureLevels (

       FeatureID            smallint NOT NULL DEFAULT 0,

       UserLevel            varchar(50) NOT NULL

                                   CHECK (Userlevel in...