PATINDEX Example

                   Let me Show Use of  PATINDEX in Sql

PATINDEX Example 

DECLARE @myString varchar(100);

DECLARE @largestInt int;

SET @myString = 'R2D2456778'

SET @mystring = @myString;

select  left(@myString, PATINDEX('%[a-z]%',substring(@myString,1,1)))

Categories: SQL