Hi Ashwin,

Try this...

select case when len(ltrim(rtrim(a1))) = 2 then

upper(a1)

when len(ltrim(rtrim(a1))) > 2 and charindex(' ',ltrim(rtrim(a1))) = 0...

Hi,

It's long winded, but you need to use the subquery three times - once in select, once in where and once in order by, i.e.

Select TableA.*,

(Select sum(acres)

from p_acres...

Hi,

A CASE expression comparing the two date columns should do the trick. The pseudo code would look something like this...

update tableb b

set controldate =case (selectmax(date1)

fromtableb a1

wherea1.customer = a.customer)

>

(selectmax(date2)

fromtableb a2

wherea2.customer...