Sybase searching with no case sensitive
Linux Server February 26th, 2007I had problem with Sybase in searching a varchar column with different character case. So, I transformed the existing character in Sybase to all lower case and then only perform the comparison.
The Sybase code below have worked on me:
SELECT full_name FROM db_name.table_owber.users WHERE LOWER(full_name) LIKE ‘%fendy%’
I learned it.
March 7th, 2007 at 10:08 pm
Waaah!! Some of your entries very techic wan, me blur blur. What is sybase?? Linus??? Are this system supportive for pc game?? Stable or not? My system clashed several time & I lost all mine saved game & have to play all over against. Sorry I ask so many question as computer info blur blur. Have a nice day.