www.webdeveloper.com
Results 1 to 2 of 2

Thread: Constructing RegExp functions in SQL

Threaded View

  1. #1
    Join Date
    Dec 2008
    Posts
    488

    Question Constructing RegExp functions in SQL

    I've been reading here: http://msdn.microsoft.com/en-us/magazine/cc163473.aspx

    I don't know very much about SQL (and I don't really need to learn to do more than simple tasks on a regular basis), so I'm having difficulty deciding how to construct a query that I can save for UPDATE statements.

    What I need to do is add in the RegExp functions and then use that to create a RegExp string that will find all HTML tags. But I have no idea where to start constructing. I will need to be able to use captures as well. Can someone show me how to construct the functions from the link above and then how to use them in an update statement? This really is just a one time thing, so I don't really want to spend a week learning UDFs and whatnot... I prefer to focus my time on client-side development.

    I'm using SQL 2005 and the columns I'm trying to use are what I think is TEXT datatype, but they're labeled TEXT in one place and MEMO in another (I don't have access to the actual server).
    Last edited by jamesbcox1980; 12-17-2009 at 05:14 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles