here's one way:

select * from YOURTABLE where PATINDEX('%[ !"#$%&''()*+,-./:;<=>?]%',YOURCOLUMN) > 0

--or

select * from YOURTABLE where YOURCOLUMN LIKE '%[ !"#$%&''()*+,-./:;<=>?]%'

there you go!

i'd step completely outside of SQL server and write something in a programming language instead.

trying to do everything from within SQL is the old "Everything is a nail"...

you are still not...

OPENROWSET command could do it, but for me that's just another flavor of a linked server; only difference is whether you devclare the server(that excel spreadsdheet) on the fly, or...

failrly easy to generate your own table of ascii chars, but i don't understand what you meant by from mulitple columns;

can you explain what you were after?

here's one example:

with Tally...

well first, I'd question...

well that's up to you...if the end user is supposed to have access to some of the procs,...

MySQL Syntax?

we'd have to see your actual code you executed;

nia.CHARINDEX really implies something you changed.

the CHARINDEX function is builtinto SQL, just like ISNULL...so if you preface it with a schema name...

- Win. (7/29/2011)

---

Hello All,

Sorry track this to another way.

- Is there anyway that to track the Logins, created date, accessed date, when it was accessed the particular database.

Is this...

defintiely the second; if you grant per item, otherwise if you drop and recreate a proc, or add a new proc you have to regrant the permissions

that's very similar...

http://technet.microsoft.com/en-us/library/ms189612(SQL.90).aspx

db_owner has all the rights of these subordinate roles as well...

basically the db_owner role can do anythign to the database..back it up, drop it, or create/change/destroy anything within that...

parameters don't do what you are expecting them to do there...@level is a string, which [by coincidence] contains commas, which makes you think it might do somethign special.

to do what...

a lot of scrambling of data is specific to the tables and lookups invloved;

I've got something that replaces all existing data with something like this (street names are a random...