>>>Is there one?
>>
>>ltrim(rtrim(upper()))
>
>So, if @Filename = "123456.tiff" then this should evaluate to true:
>
>UPPER(@Filename) LIKE '%.TIFF%'
>
>
>Mine does not for some reason.
That (your code) evaluates to true here.
I did..
declare @filename varchar(25)
set @filename = '123456.tiff'
if upper(@filename) like '%.TIFF%'
select 'Got It!'
else
select upper(@filename)
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________
