Cable Forum - View Single Post

punky · 19-08-2005, 20:44

You can, but not in SQL. SQL functions are fairly limited, but include maths ones like max, min, avg, count, etc.

You'd have to get the value with a SELECT query as per normal, and then parse the result as you want it to display.

What DBMS/Language are you using with the SQL? VB? PHP? Access?

19-08-2005, 20:44	#2
punky Inactive Join Date: Jun 2003 Age: 45 Posts: 14,750	Re: A little SQL help (possibly) You can, but not in SQL. SQL functions are fairly limited, but include maths ones like max, min, avg, count, etc. You'd have to get the value with a SELECT query as per normal, and then parse the result as you want it to display. What DBMS/Language are you using with the SQL? VB? PHP? Access?