https://sqlines.com/ 2026-04-29T14:47:29+00:00 https://sqlines.com/ https://sqlines.com/lib/images/favicon.ico text/html 2025-05-07T13:45:55+00:00 https://sqlines.com/sybase-to-mysql/single_double_quotes?rev=1746625555&do=diff In Sybase ASE and MySQL, by default you can simultaneously use both single '' and double "" quotes for string literals. Sybase ASE: -- Use single and double quotes for strings SELECT "abc", 'abc'; MySQL: -- Use single and double quotes for strings SELECT "abc", 'abc'; text/html 2025-07-13T07:30:52+00:00 https://sqlines.com/sybase-to-mysql/substring?rev=1752391852&do=diff In Sybase ASE, the SUBSTRING function returns a substring from a string, starting at the specified position and for the specified length. SUBSTRING always takes three arguments. In MySQL, you can also use the SUBSTRING function. Sybase ASE: -- Get first 3 characters SELECT SUBSTRING('New York', 1, 3); /* New */