VB Script VS SQL Query

VBS	SQL
Mid   msgbox mid(“string”,3,4)	Substr select substr(‘string’,3,4)         From dual           /
Replace msgbox replace(“I’m”,”’”,” “)	Replace
Len	Length
Lcase Ucase	Lower Upper
“ string”	‘string’
“” ‘---null	Null
Date	Sysdate
Now	Systimestamp
Strreverse(“string”)	Reverse(“string”)
5 mod 2	Mod(5,2)
Instr(1,”string”,”i”)	Instr(‘string’,’i’,1)
“a”&”b”	‘a’||’b’