how can i find value contain special character in sqlserver 2005
Database
2
Posts
2
Posters
0
Views
1
Watching
-
'34523@#$@%^@^' how can i find that above value contain special character in sqlserver 2005
-
'34523@#$@%^@^' how can i find that above value contain special character in sqlserver 2005
in sql server 2000 you can use PATINDEX which will return the index of the given pattern, or you could use LIKE. If 2k5 has support for Regular Expressions you could use those, but i havent used 2k5 yet. We're going to upgrade to 2k8 shortly though.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.