Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to use regular expression in SQL query or SSIS package?

Status
Not open for further replies.
burakcan

burakcan

Programmer
Oct 10, 2011
39
CA
Hello,
Is there a easy way to use regular expression in SQL query or SSIS package(with example please)?
Thanks for the help...
 
Sort by date Sort by votes
Much depends on what Regular Expression you need.

PATINDEX offers limited support.

You could write a C#/VB.Net CLR function, or a similar Code Script in SSIS
 
Upvote 0 Downvote
i need to searh specific wordss in a long string field.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

f0rg3tfu1
  • Locked
  • Question
PLSQL Package Help
Replies
0
Views
222
f0rg3tfu1
f0rg3tfu1
V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
383
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
373
pjw001
pjw001
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
254
Chris Miller
Chris Miller
dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
481
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top