You can add other characters to the pattern

SELECT CAST(LEFT(@StreetNumber, PATINDEX('%[-A-Z]%', @StreetNumber + 'A')-1) AS int) 
-- or
SELECT CAST(LEFT(@StreetNumber, PATINDEX('%[A-Z-]%', @StreetNumber + 'A')-1) AS int) 

>Thanks Sergey, I will. However, what if the street number is something like:
>
>305-1
>305-B
>?
>>Hi Tracy,
>>Try

>>DECLARE @StreetNumber varchar(10)
>>SET @StreetNumber =  '3505A'
>>SELECT CAST(LEFT(@StreetNumber, PATINDEX('%[A-Z]%', @StreetNumber + 'A')-1) AS int)

>>