This works

select "Answer" 
	(Case When (DuesValue01 < DuesValue02) Then DuesValue01
		Else DuesValue02
	End)
 from smctransactionsc

Thanks alot.

-----Original Message-----
From: Michael Morisoli [mailto:Michael@M...]
Sent: Thursday, June 28, 2001 10:22 AM
To: sql language
Subject: [sql_language] Re: Getting the smallest value




Try using the Case statement.

Select Answer =3D
	Case
		When Field1 < Field2 Then Field1
		Else Field2
	End
From YourTable

hth
-----Original Message-----
From: Chris Imrie [mailto:ImrieC@P...]
Sent: Thursday, June 28, 2001 9:01 AM
To: sql language
Subject: [sql_language] Re: Getting the smallest value

Hi Ken

I understand the Min() in  an Aggregate function and finds the smallest
number in a column.  I need something that compares two columns and
returns
the smallest value.

Chris