developerWorks > Information Management > Forums > IBM DB2 for Linux, Unix, and Windows Forum >

Use of Regular expressions in DB2 9.1 FOR LUW

Tags for this thread:


Search for within

My developerWorks

Welcome, Guest

	Sign in or register

This question is not answered.

Reply to this Thread

Post New Thread

Watch list

Forum settings

Help

	Replies: 1 - Pages: 1 - Last Post: Nov 6, 2009 6:16 AM Last Post By: vinni

Mokshenator

Posts: 2
Registered: Nov 06, 2009 05:25:16 AM

Use of Regular expressions in DB2 9.1 FOR LUW
Posted: Nov 06, 2009 05:28:02 AM

Can anyone tell me how to use regular expression in LOCATE function to locate a non alphanumeric character in a string?
I know the regular expression for non alphanum characters is '\W' but not able to implement it correctly in the function.
I am working on DB2 9.1 version for LINUX, UNIX AND WINDOWS

Thanks in Advance

vinni

Posts: 77
Registered: Dec 28, 2007 07:56:43 AM

Re: Use of Regular expressions in DB2 9.1 FOR LUW
Posted: Nov 06, 2009 06:16:20 AM

in response to: Mokshenator's post

Hi,

You can check this article.

Bringing the Power of Regular Expression Matching to SQL

Thanks

Pages: 1

Back to Thread List

Tags

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

Popular forum tags

My forum tags

Popular forum tags

My forum tags

More

Less

Update your My developerWorks profile and start connecting with others.