Home Forums SQL Server 2012 SQL Server 2012 - T-SQL More than 1 alphanumeric chars in a string RE: More than 1 alphanumeric chars in a string

  • April 8, 2014 at 6:10 pm

    #1704346

    Try:

    SELECT

    *

    FROM

    #employee

    WHERE

    Surname LIKE '%[^0-9a-zA-Z][^0-9a-zA-Z]%'

    OR GivenName LIKE '%[^0-9a-zA-Z][^0-9a-zA-Z]%';

    GO