Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 tsql functions for maximum of tow values

Author  Topic 

jeff06
Posting Yak Master

166 Posts

Posted - 2009-08-11 : 22:43:39

table
x1
1
2
8
9
11
23
34
23


I need to find the max of x1 and 10, does tsql has a function for that? max(x1,10) does not work.
Thanks.
Jeff

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-08-11 : 23:09:31
it does not. use case when . . . to do it


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -