Posted by dbahooker on 09/28/05 17:35

TSQL friggin rocks for string manipulation


i would reccomend replacing the # symbol and then inserting it
or better yet.. you should clean your data ONCE and dont do crap like
store 'STORE #61' in a text field-- can't you just store 61? as an int?

so you have clean data??

• Next in forum: Re: Connecting Trace info to blocked users?
• Prev in forum: Re: SA can not create users
• Thread view: Re: Howto Format a string in a sproc ?

[Reply to this message]