In MS SQL Server, is there an alternative to PatIndex? I have the Select Query below which currenly uses the PatIndex function but is there another way this can be with a different function? The purpose of this query is to identify invalid chars in a column.
WHERE PatIndex('%[^a-z0-9]%', [Addresses.txt].[PROD_CD]) > 2