Regular Expression

  • Can we write regular expression in sql server express 2005?

    and can we use regular expression in creating search string?

  • nidhivarshney82 (5/11/2010)


    Can we write regular expression in sql server express 2005?

    and can we use regular expression in creating search string?

    The short answer is yes. The Sql Clr is available in Sql Express as it is in other versions of Sql Server.

  • How can we use it in creating search query? Can you give me some examples?

  • nidhivarshney82 (5/20/2010)


    How can we use it in creating search query? Can you give me some examples?

    Assuming:

    1. You are comfortable coding in any one of the .Net Languages.

    2. You have the necessary access rights to enable the CLR on the Sql Instance.

    This should help:

    http://msdn.microsoft.com/en-gb/magazine/cc163473.aspx

  • Thanks cK ...

    That's the nice article..

  • Glad I could help 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply