Check this out: http://www.codeproject.com/managedcpp/xpregex.asp
Will work for 32 bit MSSQL; but not on 64bit. Dharmendar Kumar Email/ Fax Communications: http://www.realmagnet.com Web Development: http://www.daksatech.com -----Original Message----- From: James Smith [mailto:[EMAIL PROTECTED] Sent: Monday, June 04, 2007 8:53 AM To: SQL Subject: Regex in MSSQL I am looking for a Regex solution recommendation, what I really want to be able to do (for example) is... SELECT something FROM somewhere WHERE somefield LIKE '\b#form.someField#%' Where the \b represents a word boundry in regex. The closer I can get to this the better, something like... WHERE somefield LIKE 'regex(\b)#form.someField#%' Where regex is calling some function or other would also be fine. Anyone any suggestions or recommendations? -- Jay ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2874 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
