Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VAL() type of function?
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
VAL() type of function?
Miscellaneous
Thread ID:
00825781
Message ID:
00825781
Views:
67
I have a column VarChar(15) that I need to find the highest value in. It's a part # and I need to add a 1 to the existing part #.

ALL-15, FLR-142A, MAK-97W, ZR-5

I could cheat in VFP with a VAL(). How can I pull this out in a Select Statment?

TIA

__Stephen
__Stephen Russell
>>
"Simplicity is the ultimate sophistication."

Leonardo da Vinci

>> My old crummy site.
Next
Reply
Map
View

Click here to load this message in the networking platform