- Feature Articles
- CodeSOD
- Error'd
- Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
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.
Admin
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.
Admin
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.
Admin
(Sing to the tune of Band-Aid)
Feed the Troooooooooolls,
Let them know that VB really sux...
-dZ.
Admin
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.
Admin
Admin
Eh? What's wrong with how it looks in Opera? I'm using Opera right now and it looks identical in IE.
Admin
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.
Admin
So true it hurts.
Admin
vb mimicking lisp, wtf!
Admin
is there a daily wtf analogy dot com somewhere?
Admin
GAAAAAAAAAAAH!
Strings in VB6 are NOT immutable. Where do people get this idea?
example:
a = "Foo"
mid$(a,2,1) = ""
debug.Print a
Result:
"Fo"
Strings in VB6 can be changed, they are not immutable.
Admin
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.
Admin
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.
Admin
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
Admin
Actually I find there's something beautifully recursive about the Daily WTF's forum software being the way it is.
Admin
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.
Admin
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.
Admin
*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>Admin
Poo on regexp... use codegen for these situations!
Admin
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.
Admin
Admin
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.