Here is a list of regular expressions that work for me in Visual Studio when locating/replacing text in SQL.

• generate scripts tasks for data will turn dates in to HEX. For example, it will turn a row_created_data column into  CAST(0x000063DF01035C97 AS DateTime). I want to change those dates to GETDATE(): search for 'CAST\(0x:h AS DateTime\)' (:h searches for hex values)

Remove trailing spaces in a quoted insert statement: (Find) :Zs#', (Replace) ',