Yeah, that's what I figured. I was hoping to do it without an OR, but I can't
see another way around it, etiher.
> I'm not 100% sure on how you want your logic to work but would something
> like this work for you?
> when len(rtrim(col1)) = 0 or rtrim(col1) is not null
> then col1
> else ...
> > Yup. You can see what the old behaviour was in BOL2K, sp_dbcmptlevel.
> > My problem is that my code is going to have to work in both systems for a
> > weeks while we migrate.
> > Paul
> > > I'm not sure what you're saying the problem is. RTRIM('') returns '' in
> > > SQL2K, which is what I expect to happen. Are you saying that in 6.5 it
> > > returned NULL?
> > > Zach
> > > > Hi all,
> > > > Here's what I'm trying to do:
> > > > SELECT CASE WHEN RTRIM(col1) IS NOT NULL THEN col1
> > > > ELSE...
> > > > END
> > > > FROM sometable
> > > > Now this works just fine in SQL65. In SQL2K, RTRIM an emtpty string
> > > > you '', which is not NULL.
> > > > So, how can I perform this check in a way that will work in both
> > > > systems?
> > > > And I don't want to set my dbcmptlevel to 65.
> > > > Thanks,
> > > > Paul