LEN Function Not Working

[ChetShah]

Hi Everyone,

I'm getting very strange results on 2 SQL 6.5 boxes (yes ok i know they are ancient) when using the LEN function. The query i run is:

Select len(Last_Update) from prod_authorisation

On first box i get -
Msg 195, Level 15, State 10
'len' is not a recognized built-in function name.

On second box i get


-----------
8
8
8

So how come it works on one and not the other??
Both databases have Select Into/Bulk Copy option turned on

 

[SQLBill]

Do they both have the same Service Pack applied? I have two SQL 2000 boxes and both were doing different things (SET NOCOUNT ON worked on one but not the other). I noticed that I had didn't have a Service Pack on the one that didn't work and SP 2 on the one that did work. So, I applied SP2 to the one that didn't work and what do you know....it worked. (Of course, I now have SP3 applied to all of my systems)

-SQLBill