Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
T-SQL logic
Message
From
14/01/2009 10:39:32
Sergey Berezniker
New York, United States
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: T-SQL logic
Miscellaneous
Thread ID:
01373545
Message ID:
01373552
Views:
20
>Thank you Sergey. This does exactly what I need.
>
you're welcome and I think you can simplify it alittle bit
IF @IntNumber % 100 = 0 
	SELECT CAST(@InputNuber AS int)
ELSE
	SELECT @IntNumber
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform