• David (unregistered) in reply to Manni

    Just wondering, what expression did you test with?  I wrote a quick app in C++ to remove unwanted characters and I wanted to compare speeds, but obviously comparing my speed to yours is pointless without knowing the expression you used to test it. 

  • JThelen (cs) in reply to Manni
    Manni:

    Mung Kee:
    Manni:
    At what point does it become wasteful to spend this much time devising a barely noticeable performance improvement?

    At the point that you decided to use VB.

    Disclaimer: I'm not a VB-hater.  It's just no Porsche.

    If my shitty car gets up to 60 mph in the same time a Porsche can get to 130 mph, I call that a significant difference. If you think you can save a few hundreths of a millisecond by using one language as opposed to another, then I'm not convinced your language is better.

    And by the way, I was looking for a real answer, not a smart-assed comment that provided no further insight about when the coding time investment does not yield appropriate performance returns.

    "Ha ha VB sux"...yeah, thanks for contributing.



    Jesus, when did you turn into a proVB troll? 

    If the fact of the matter is that VB sucks for something, and coding something proper results in slowdown, then it sucks, end of story.  The fact that you have to write crap like this instead of using a properly coded solution speaks volumes in and of itself. 

    Noone here is saying 'ha ha VB sux' like you seem to be insinuating in every VB WTF of late, but if the best way to do something is absolute shit, then buck up and deal with the fact that your apparently beloved VB requires you to write pisspoor code for optimal results.
  • Mung Kee (cs) in reply to Manni
    Manni:

    And by the way, I was looking for a real answer, not a smart-assed comment that provided no further insight about when the coding time investment does not yield appropriate performance returns.

    "Ha ha VB sux"...yeah, thanks for contributing.



    Asshat, you, me and the rest of the readers know your question was rhetorical, so when you say you were looking for a real answer, I say bullshit.  And as Jake implied, take the three or four minutes to learn RegExp.  It keeps on giving (though it's likely out of the realm of the average VB evangelist).  For the record, I never said it "sux" and don't believe it does, but if you believe that VB isn't one of the slowest performing of the mainstream languages then you have tunnel-vision.
  • DZ-Jay (cs) in reply to Mung Kee
    Mung Kee:
    Manni:

    And by the way, I was looking for a real answer, not a smart-assed comment that provided no further insight about when the coding time investment does not yield appropriate performance returns.

    "Ha ha VB sux"...yeah, thanks for contributing.



    Asshat, you, me and the rest of the readers know your question was rhetorical, so when you say you were looking for a real answer, I say bullshit.  And as Jake implied, take the three or four minutes to learn RegExp.  It keeps on giving (though it's likely out of the realm of the average VB evangelist).  For the record, I never said it "sux" and don't believe it does, but if you believe that VB isn't one of the slowest performing of the mainstream languages then you have tunnel-vision.


    (Sing to the tune of Band-Aid)
    Feed the Troooooooooolls,
    Let them know that VB really sux...

        -dZ.

  • PstScrpt (cs) in reply to dubwai

    dubwai:

    Why would one do any of these?  Is there no mutable String type in VB or something? Can you not create Strings from arrays of characters?

    No, there's no mutable string type (at least in QuickBasic through VB6). 

    To create a string from an array of characters, the language would have to have a character type, which it doesn't.  When you need to store a character, you use a string that just happens to be really short.

  • Special (unregistered) in reply to DZ-Jay
    DZ-Jay:
    As far as I know, Perl is one of the few (the only) programming languages that integrate Regular Expressions into their core syntax.  (Just like god intended RegExps to be.)
     
    The only language more hated around here than VB: JavaScript has built in regex syntax.
  • Thomas G (unregistered) in reply to JThelen
    JThelen:
    unless you want to get into how the site displays in Opera or Safari.  That's just a standard MS WTF.

    Eh? What's wrong with how it looks in Opera? I'm using Opera right now and it looks identical in IE.

  • Hank Miller (unregistered) in reply to Manni
    Manni:

    If my shitty car gets up to 60 mph in the same time a Porsche can get to 130 mph, I call that a significant difference. If you think you can save a few hundreths of a millisecond by using one language as opposed to another, then I'm not convinced your language is better.



    I'm convinced that knowing how to program is worth more than any language.   Judging from this site, I can do better at visual basic this afternoon than many people who have been doing VB for years, even though everything I know about VB I learned from their examples here.

    My Geo Metro often beats Porsche's to freeway speed, entering a busy freeway, and it isn't even running on all cylinders.   I'm pretty sure this is a reflection on how bad many Porsche drivers are, not my skill, or my car's abilities.   

    A good driver doesn't need a good car, and a good programmer doesn't need a good language.   However given a choice the good programmer and driver will prefer the better language/car, but they can get results from a lot less.    (In my case it is just hard to argue with 45mpg when you drive > 100 miles a day)

    A bad driver cannot get good results from a good car, and a bad programmer will not get good results from a good language.
  • whojoedaddy (cs) in reply to Humble merc coder

    Anonymous:
    umm... I wrote it to spec

    ...And thus begins many a sad tale.

     

    So true it hurts.

  • zorro (unregistered)

    vb mimicking lisp, wtf!

  • zorro (unregistered) in reply to Hank Miller
    Anonymous:
    Manni:

    If my shitty car gets up to 60 mph in the same time a Porsche can get to 130 mph, I call that a significant difference. If you think you can save a few hundreths of a millisecond by using one language as opposed to another, then I'm not convinced your language is better.



    I'm convinced that knowing how to program is worth more than any language.   Judging from this site, I can do better at visual basic this afternoon than many people who have been doing VB for years, even though everything I know about VB I learned from their examples here.

    My Geo Metro often beats Porsche's to freeway speed, entering a busy freeway, and it isn't even running on all cylinders.   I'm pretty sure this is a reflection on how bad many Porsche drivers are, not my skill, or my car's abilities.   

    A good driver doesn't need a good car, and a good programmer doesn't need a good language.   However given a choice the good programmer and driver will prefer the better language/car, but they can get results from a lot less.    (In my case it is just hard to argue with 45mpg when you drive > 100 miles a day)

    A bad driver cannot get good results from a good car, and a bad programmer will not get good results from a good language.


    is there a daily wtf analogy dot com somewhere?
  • RayS (cs) in reply to zorro

    GAAAAAAAAAAAH!

    Strings in VB6 are NOT immutable. Where do people get this idea?

    example:
    a = "Foo"
    mid$(a,2,1) = ""
    debug.Print a

    Result:
    "F
    o"

    Strings in VB6 can be changed, they are not immutable.

  • PstScrpt (cs) in reply to RayS
    RayS:
    GAAAAAAAAAAAH!

    Strings in VB6 are NOT immutable. Where do people get this idea?

    example:
    a = "Foo"
    mid$(a,2,1) = "*"
    debug.Print a

    Result:
    "F*o"

    Strings in VB6 can be changed, they are not immutable.


    Alright, yes, I forgot about that.  That only works, though, when the length of the string isn't going to be changing, which is pretty rare.
  • Suomynona (unregistered) in reply to JThelen
    JThelen:

    As to the 'whole site' being one big WTF, the only real issue is the javascript page browsing.  Everything else is sporadic enough that it qualifies as a PEBKAC error, not a problem with the site itself, unless you want to get into how the site displays in Opera or Safari.  That's just a standard MS WTF.


    Pityful apologies

    Post #121. Sorry for not linking to the post in question - that doesn't seem possible, either. I'm now entering the second third captcha so I can post.

  • tufty (cs) in reply to Suomynona

    I'm now entering the second third captcha so I can post.

    It's not just you. If you use an browser / OS combination that doesn't throw up the Javascript editor, you will find a complete inability to edit as anything other than plain text, bbcode tags will not work, previewing will appear to work, and then post vast amounts of unreadable htmlised shite, etc.

    the captcha stuff is deeply irritating for unregistered users.

    On the whole, this forum software is under-featured, under-developed, and basically just plain sucks.

    It says something for the quality of the WTFs posted here that people ever bother coming back.

    simon

  • joost (cs) in reply to tufty

    Actually I find there's something beautifully recursive about the Daily WTF's forum software being the way it is.

  • JThelen (cs) in reply to tufty
    tufty:
    > I'm now entering the second third captcha so I can post. It's not just you. If you use an browser / OS combination that doesn't throw up the Javascript editor, you will find a complete inability to edit as anything other than plain text, bbcode tags will not work, previewing will appear to work, and then post vast amounts of unreadable htmlised shite, etc. the captcha stuff is deeply irritating for unregistered users. On the whole, this forum software is under-featured, under-developed, and basically just plain sucks. It says something for the quality of the WTFs posted here that people ever bother coming back. simon


    Yes, the Captchas are a PITA.  Registering will get you around them, but for those who'd prefer to stay anonymous and troll more than contribute, I say fuck em.

    While the forum software has less features than you'd find in phpBB or some of the other forum software out there, it's also far less prone to being hacked, as far as I can tell. 

    Overall, I'm not a huge fan of it;  I think Alex would have done himself(and all of us, for that matter) a huge favor if he'd taken Slashcode and modified that to meet his own ends.
  • Manni (cs) in reply to Mung Kee
    Mung Kee:
    Manni:

    And by the way, I was looking for a real answer, not a smart-assed comment that provided no further insight about when the coding time investment does not yield appropriate performance returns.

    "Ha ha VB sux"...yeah, thanks for contributing.

    Asshat, you, me and the rest of the readers know your question was rhetorical, so when you say you were looking for a real answer, I say bullshit.  And as Jake implied, take the three or four minutes to learn RegExp.  It keeps on giving (though it's likely out of the realm of the average VB evangelist).  For the record, I never said it "sux" and don't believe it does, but if you believe that VB isn't one of the slowest performing of the mainstream languages then you have tunnel-vision.

    Wow I didn't expect such an angry response from so many people.

    Mung Kee: I thought I was clear with my point that I did try RegExp, and it was a slower solution. It's certainly prettier to look at code-wise, but I'm not about to tell my users that they have to deal with slower software because I had to make the code look nice. I totally agree that VB produces probably the slowest performing compiled programs. However, in my line of work, it's not processing speed that is the biggest factor, it's development time.

    I work with seasoned C++/C# programmers, and if we start the same task in our language of choice, it's guaranteed I'll finish way ahead of them. Their software will run a few seconds faster because the language is better optimized, but no one will notice that if they have to wait hours or days longer for the code to be finished.

    David: The expression I tested with was with the RegExp object's Replace function using "[a-zA-Z0-9]".

    JThelen: I didn't realize I was trolling, I thought I was just trying to make the same point that Hank Miller eloquently stated: any language is good in the right hands, and any language can be an atrocity in the wrong ones.

  • Mike Labosh (unregistered)

    *They made me add this update* to a stored procedure (after much protest and many meetings):

    <FONT size=1>

    </FONT><FONT color=#008000><FONT face="Courier New" size=2>-- Save yourself the trouble and don't even ask. SHEESH!</FONT>

    </FONT>

    <FONT size=2><FONT face="Courier New"><FONT color=#0000ff>UPDATE </FONT>SampleSourceArchive <FONT color=#0000ff>WITH </FONT>(<FONT color=#0000ff>ROWLOCK</FONT></FONT><FONT face="Courier New">)</FONT></FONT>

    <FONT size=2><FONT face="Courier New"><FONT color=#0000ff>SET </FONT>CompanyName = <FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(CompanyName, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">CompanyPhoneArea = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(CompanyPhoneArea, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">CompanyPhoneNumber = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(CompanyPhoneNumber, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">CompanyAddress1 = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(CompanyAddress1, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">CompanyAddress2 = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(CompanyAddress2, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">CompanyAddress3 = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(CompanyAddress3, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">City = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(City, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">StateProvince = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(StateProvince, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">PostalCode = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(PostalCode, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">Country = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(Country, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">SubIndustryCode = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(SubIndustryCode, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">SicCode = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(SicCode, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">RdhType = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(RdhType, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">RdhID = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(RdhID, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">WWCustomerNumber = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(WWCustomerNumber, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">DunsNumber = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(DunsNumber, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">EstablishmentSize = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(EstablishmentSize, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">ContactTitle = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(ContactTitle, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">FirstName = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(FirstName, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">FullName = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(FullName, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">ContactJob = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(ContactJob, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">ContactPhoneNumber = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(ContactPhoneNumber, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">IbmContactNumber = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(IbmContactNumber, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">ProductVendor = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(ProductVendor, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">ProductName = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(ProductName, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">SoftwareVersion = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(SoftwareVersion, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">SoftwareOS = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(SoftwareOS, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">HardwareSeries = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(HardwareSeries, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">HardwareProductGroup = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(HardwareProductGroup, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">SoftwareProductID = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(SoftwareProductID, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">SoftwareComponentID = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(SoftwareComponentID, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">SoftwarePartNumber = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(SoftwarePartNumber, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">HardwareModel = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(HardwareModel, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">HardwareMachineType = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(HardwareMachineType, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">ContactEmail = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(ContactEmail, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">CompanyNameLong = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(CompanyNameLong, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">InterviewLanguage = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(InterviewLanguage, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">Salutation = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(Salutation, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">CompanyNameAbbreviation = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(CompanyNameAbbreviation, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">UniversalCountryCode = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(EmailFlag, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">EmailFlag = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(EmailFlag, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), ''))),</FONT></FONT>

    <FONT size=2><FONT face="Courier New">SurveyFlag = </FONT><FONT face="Courier New"><FONT color=#0000ff>LTRIM</FONT>(<FONT color=#0000ff>RTRIM</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>REPLACE</FONT>(<FONT color=#0000ff>ISNULL</FONT>(SurveyFlag, ''), <FONT color=#0000ff>CHAR</FONT>(10), ''), <FONT color=#0000ff>CHAR</FONT>(13), ''), <FONT color=#0000ff>CHAR</FONT>(34), ''), <FONT color=#0000ff>CHAR</FONT>(145), ''), <FONT color=#0000ff>CHAR</FONT>(146), ''), <FONT color=#0000ff>CHAR</FONT>(147), ''), <FONT color=#0000ff>CHAR</FONT></FONT><FONT face="Courier New">(148), '')))</FONT></FONT>

    <FONT face="Courier New"><FONT size=2><FONT color=#0000ff>WHERE </FONT>SampleSourceKey = @sampleSourceKey</FONT></FONT>

    <FONT face="Courier New" size=2></FONT> 

    <FONT face="Courier New" size=2>-- Oh, and then there was this other one that does SERIOUS heavy lifting that is over 7 pages long.  Then a coworker discovered that it has to operate in two different modes to support an optional parameter, so now it looks like this:</FONT>

    <FONT face="Courier New" size=2>IF @clmrKey IS NULL</FONT>

    <FONT face="Courier New" size=2>BEGIN</FONT>

    <FONT face="Courier New" size=2>   -- 7 pages of code</FONT>

    <FONT face="Courier New" size=2>END</FONT>

    <FONT face="Courier New" size=2>ELSE</FONT>

    <FONT face="Courier New" size=2>BEGIN</FONT>

    <FONT face="Courier New" size=2>   -- 7 pages of the same identical code with one phrase of the WHERE clauses changed</FONT>

    <FONT size=1><FONT face="Courier New" size=2>END</FONT>

    </FONT>
  • Mark L. (unregistered)

    Poo on regexp... use codegen for these situations!

  • Quinnum (cs) in reply to Mike Labosh
    Anonymous:

    *They made me add this update* to a stored procedure (after much protest and many meetings):

    <FONT size=1>

    </FONT><FONT color=#008000><FONT face="Courier New" size=2>-- Save yourself the trouble and don't even ask. SHEESH!</FONT>

    </FONT>

    OMFG!

    But a big WTF is why where there are bloody carriage returns and line feeds in the data in the first place ????

    Data validation on input == good.

     

  • DWalker59 (cs) in reply to RayS
    "Strings in VB6 can be changed, they are not immutable."
     
    Strings in VB6 are immutable at the lowest level, and they can be changed.  When you change a string, the original underlying string is destroyed and a new string is created.
     
    You need to know this if you care about performance in an application that does a lot of string manipulation.
     
    Try Google for VB string immutable.  One reference is http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcn7/html/vaconstringsinvisualbasic.asp (which is for VB.NET but I'm pretty sure it applies to all earlier VBs such as VB6).
     
    David Walker
  • foxyshadis (cs) in reply to PstScrpt
    PstScrpt:

    dubwai:

    Why would one do any of these?  Is there no mutable String type in VB or something? Can you not create Strings from arrays of characters?

    No, there's no mutable string type (at least in QuickBasic through VB6). 

    To create a string from an array of characters, the language would have to have a character type, which it doesn't.  When you need to store a character, you use a string that just happens to be really short.


    That's very funny, because I've been using VB byte arrays for years! (The rare times I use VB.) They aren't unicode, unless you use custom unicode access functions, and you have to use idioms that are more similar to C than VB to work with them, but their performance in heavy loops is massively better than the immutable String type.

Leave a comment on “Just in case SPACE isn't supported in the future”

Log In or post as a guest

Replying to comment #:

« Return to Article