|
|
Posted by Erland Sommarskog on 08/26/05 13:42
wirelessguy (law_40@hotmail.com) writes:
> based on the informaiton provided, i would have to use the first
> suggestion. However, does the min() funtction work with non numeric
> values? my picture ID's are text.
Yes, MIN() works with varchar values. (I assume you don't mean the
data type text, because that would be a funny thing to use for a file
name.)
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|