Hello, I would like replace a portion of a string that is a SQL statement generated by my users via an interface that I have created. I have never used Regular Expressions but from what I have heard about this task sounds like a candidate.
I would like to update a SQL statement that is generated by my users there is a portion of the string that says "set primary_assign_id = 123" that I would like to remove the problem is that I am not sure what the number is but I know that it always three numbers. How can I do this? Regards, Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192608 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54