upper case issue in replace function

[Joey Martin]

I just realized that when I do a replace:
replace(rs("IMAGE"),".jpg","")

it replaces all instances of a lower case .jpg but not the upper case
..JPG

How can I fix this?

 

[Ray at]

Binary comparison vs. text comparison (the "compare" argument). See here.

http://msdn.microsoft.com/library/en-us/script56/html/vsfctreplace.asp

Ray at work