Hi Thusha,

There wont be problem in retrieving data, if the data that you have inserted is upto correct data type and the length.

i am not quite sure what you mean by the part of data.

but i guess, you would like to retrieve "University of Colombo" even you specify "University" in query. if that so, that is to do with query formulation.

Say, it can be

SELECT * FROM MyUniTable WHERE column_name LIKE '%university%'

Have some refrence in the following how you can formulate queries lot of different specific to your needs-

http://www.w3schools.com/sql/sql_quickref.asp 
 
if this not what your are looking, post again