[Solved] Find and Replace for a string in Notepad++ using regular expression

by

[ad_1]

Is that what you want?

Find what: (\w+)?.+?(VARCHAR.+) NULL
Replace with: cast\(NULL as $2\) as $1

Don’t forget to escape the parenthesis in the replacement part!

1

[ad_2]

solved Find and Replace for a string in Notepad++ using regular expression