I get incorrect result when i try to do a substring within a stored proc,but the same thing if i try it in a query window gives me proper results.
declare @FinalCol_List as varchar(100)
Set @FinalCol_List= '11,22,33,bb,'
print @FinalCol_List
IF LEN(@FinalCol_List) > 0
SET @FinalCol_List = SUBSTRING(@FinalCol_List, 1, LEN(@FinalCol_List) - 1)
print @FinalCol_List
Subscribe to:
Post Comments (Atom)
The belt mаkeѕ use of gеl pаԁs postionеԁ mοrе than thе centeг abdοminals anԁ the outside oblіques.
ReplyDeleteHere is my web site; flex belt
my page > Www.prnewswire.Com
Share Market calls
ReplyDeletecommodity Tips
Freetrial Tips
Stock Cash Tips
Stok Market/News Blog
WAYS2CAPITAL STOCK ADVISORY FIRM
ReplyDeletecommodity- tips
stock- tips
WAYS2CAPITAL STOCK ADVISORY FIRM
ReplyDeletecommodity-tips
stock-tips
Share Market Investment made profitable by SHRISTOCKTIPS- Get NSE/BSE Tips via SMS and Yahoo Messenger. We give daily stock market tips for future and cash segments.Epic Research
ReplyDeleteThe given updates about share market are helpful in trading and you can get more financial advices from Dollar Advisory at Trading Services
ReplyDeleteThis is good content blog keep it up; you can also search at TradeIndia Research
ReplyDeleteI am happy to find so many useful information here in the post,thanks for sharing.
ReplyDelete2 Days Free Research Advisory Tips
Regular sets a option to make a large system in the market to trade with a position.
ReplyDeleteBest Equity Intraday tips
Free Commodity Trading Tips