Search string with case or no-case in API and SQL way

[info at vallemediatime.com]

Hi Ruslan and list,
I've seen that in V2 the case and no-case search are changed. 
In API way seems to me that searching works in 'no_case' setting;
in SQL way the searching works in 'case' setting... right?

Can you tell me more informations? Or where to find it?
Thanks


Now I want try thid query with 'no_case' setting but I need some help.

on searchByString
searchString = member("searchString").text
gCursor = 0
query = "SELECT RecID, * from STUDENTI\
WHERE '" & searchString & "' IN\
(sF1, sF2, sF3, sF4, sF5, sF6, sF7, sF8, sF9, sF10,\
sF11, sF12, sF13, sF14, sF15, sF16, sF17, sF18, sF19, sF20,\
sF21, sF22, sF23, sF24, sF25, sF26, sF27, sF28, sF29, sF30)"
gCursor = gDb.sqlSelect(query, #kServer, #kReadWrite, #kRandom)
if CheckValError() then exit
updateResultGrid()
end

I must insert 'no_case' like V1 or what?
Thanks
Paolo