Ispirer SQLWays Database Migration Software

Using OS Special Characters

Microsoft Windows interprets such characters as %,| as the OS special characters. Thus, if you want to use them in the command line or batch files, you have to duplicate them.

Use:

SQLWays /d=dsn /s=select * from t1 where field1 like '%%123%%' 

instead of

SQLWays /d=dsn /s=select * from t1 where field1 like '%123%' 

Microsoft Windows treats the character > as a redirection character. If you want to use this character in the SELECT statements, you have to enclose the statement in double quotes:

SQLWays /d=dsn /s="select * from t1 where field2 > 123" 

             

Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.