• yes you can, SQL supports some regular expressions:

    WITH

    MyLastNames(LName) AS

    (

    Select 'DeCaprio@gmail' UNION ALL

    Select 'Pitt[phone]' UNION ALL

    Select 'Schwarzenegger(phone)' UNION ALL

    Select 'Wahlberg' UNION ALL

    Select 'Damon' UNION ALL

    Select 'Willis'

    )

    SELECT

    B.LName

    FROM MyLastNames B

    WHERE B.LName LIKE '%[!@#$%^&*()]%'

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!