Jeff Moden
SSC Guru
Points: 1000539
More actions
August 11, 2008 at 5:59 pm
#856434
shamshad.ali (8/11/2008) I need to list them down. if there is a way. also how should i exclude space" " and dot"." from [a-z0-9] Thanks all for help... Shamshad Ali.
shamshad.ali (8/11/2008)
Thanks all for help...
Shamshad Ali.
Shamshad... have you tried Peso's script?
--Jeff Moden
shamshad.ali
Hall of Fame
Points: 3850
August 11, 2008 at 11:09 pm
#856494
SELECT * FROM tbl_user
WHERE UserName LIKE '%[^a-z0-9 ._-]%'
This gives me the result of all those specail characters like $ and hyphen and so on. Its fine. Thanks, Thanks everyone ...
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply