How to add a char or string prefix to specific column in a SQL table and then remove that prefix later

Jump to: navigation, search

Sometimes for debug purposes it is helpful to add a char prefix to specific column in a SQL table. Then when debug is complete you want to undo that prefix. In the example below the prefix char is the percent sign. update myTable set myColumn = '%' + myColumn where ... Then to undo update myTable set myColumn = myColumn ( myColumn ,2 , len(myColumn) -1 ) Where SUBSTRING ( DISPLAY ,1 , 1 ) = '%' AND the where clause you used above

See also

Use your Android as a remote for garage door

Personal tools
Namespaces
Variants
Views
Actions
Navigation