Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by HIC

  1. HIC

    Using Max and Min with the Money datatype

    SQL 7
  2. HIC

    Using Max and Min with the Money datatype

    Thanks for the reply I have a table of 10 rows. All have either a 999 or 1000 in a field called Money. Select Emp_id, min(Money)as minimum, max(Money) as maximum from testtable where emp_id=3456 group by emp_id
  3. HIC

    Using Max and Min with the Money datatype

    When I try to get the max and min of a column with a money datatype it brings back 1000 as min and 999 as max. Obviously, I need 1000 to be the max. I have tried to cast and convert this to different datatypes, but have been unable to make this work properly. Any ideas? Thanks! HIC
See more

Part and Inventory Search

Back
Top