Actually, there's a dll you can get to add regex support to sql server too.
http://databasepronews.com/articles/0220df.html I rule. -----Original Message----- From: Wjatscheslaw Kravtchenko [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 4:25 PM To: CF-Talk Subject: OT: Think you are a SQL GURU? Try figuring this one out. Hey Eric, It's not SQL it's more for PERL and Regular Expressions. I am not too familiar with regular expressions in ColdFusion but I'm sure that they are no RegEx in SQL. Another thing what could do it would be kdb from KX Systems but again you need to learn k. If you can drop me the csv file (please not more than 3 mb). I can have a look. SL >Here is the challenge. > >Have a table with a column called NAME and the column contains both >names of businesses and individuals. Business names are stored as is , >example ABC Company. Individuals are stored as last name first name >middle initial, example Public John Q. I need to get this information >into another table where the biz name can be stored in the first name >field no problem but I need to parse and individuals name so I can put >the individual's first name in the first name column and their last >name in the last name column. > >Figure it out and I will send you a prize. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
