[thelist] SQL SELECT and RegEx
Jeffrey Barke
jeffrey.barke at themechanism.com
Wed Dec 12 14:26:51 CST 2007
>> Ps. The bad news is it's Access not MS SQL or MySQL.
Sorry--missed the fact that it was Access.
> With Access you are severely limited. Unless there are extremely
> uncommon
> circumstances at foot, there's little to no reason to stick with
> that--I'd
> highly recommend that you switch to MS SQL Server or something more
> powerful. Search for MSDE to find a free version of SQL Server.
I agree with Joshua. I would never use Access in a production
environment.
> Is it possible to run an SQL SELECT statement and apply a
> regular expression
> to a field that will manipulate the data returned at the time
> of running the
> SELECT?
However, you can still use Access's Replace() function to remove
specific tags.
Jeffrey
--
Cheers.
Jeffrey Barke
jeffrey.barke at theMechanism.com
Lead Developer, US
theMechanism - New York City
440 9th Avenue, 8th Floor
New York, NY 10001-1631
t: +1 212.404.3150
c: +1 917.941.1232
f: +1 212.404.3228
http://www.theMechanism.com
Subscribe to theMechcast, our monthly Podcast:
http://feeds.feedburner.com/theMechcast
theMechanism - London
3rd Floor
405 The Strand
London E14 9FW
United Kingdom
t: +44 (0)20 7240 4964
f: +44 (0)20 7240 2262
--
The information contained in this Electronic mail message is attorney
privileged and confidential information intended only for the use of
the individual or entity named above. Such information also is
intended to be privileged, confidential, and exempt from disclosure
under applicable law. If the reader of this message is not the
intended recipient or the employee or agent responsible to deliver it
to the intended recipient, you are hereby notified that any
dissemination, distribution, or copying of this communication is
strictly prohibited. If you have received this communication in
error, please notify us immediately by telephone.
Blah, blah, blah...
--
On Dec 12, 2007, at 3:13 PM, Joshua Olson wrote:
>> -----Original Message-----
>> From: Chris Dempsey
>> Sent: Wednesday, December 12, 2007 2:46 PM
>>
>> Hi,
>>
>> Is it possible to run an SQL SELECT statement and apply a
>> regular expression
>> to a field that will manipulate the data returned at the time
>> of running the
>> SELECT?
>>
>> Ps. The bad news is it's Access not MS SQL or MySQL.
>
> Chris,
>
> With Access you are severely limited. Unless there are extremely
> uncommon
> circumstances at foot, there's little to no reason to stick with
> that--I'd
> highly recommend that you switch to MS SQL Server or something more
> powerful. Search for MSDE to find a free version of SQL Server.
>
> Then, you can have access to UDFs, which then gives you the ability
> to use
> Regex:
>
> http://blogs.msdn.com/khen1234/archive/2005/05/11/416392.aspx
>
> <><><><><><><><><><>
> Joshua L. Olson
> WAE Technologies, Inc.
> http://www.waetech.com/
> Phone: 706.210.0168
> Fax: 413.812.4864
> Private Enterprise Number: 28752
>
> Monitor bandwidth usage on IIS6 in real-time:
> http://www.waetech.com/services/iisbm/
>
> --
>
> * * Please support the community that supports you. * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
More information about the thelist
mailing list