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??

[Back to original message]