General information
Forum:
Microsoft SQL Server
Title:
Calculating a Reference String
Environment versions
SQL Server:
SQL Server 2005
Hi,
Our tables have a reference field which the user can type into. The field can contain pretty much anything the user can think of e.g.
AAA
AZ49
Glasgow/01 etc.
However, the user can also ask the system to calculate the next reference.
In our system, the string AAAA would be greater than ZZZ, and the reference after AAAA would be AAAB.
Using MAX() in the above example would return ZZZ, when we would want AAAA returned.
Is there a SQL statement which would return what we consider to be the maximum reference?
Matt.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only