Hi i need your help i want a query...
i have a question for you suppose i have table name person in that column name description which contains the below words The govt has asked airlines to issue an all-inclusive and reasonable fares in a consumer-friendly manner, something that only Air India (domestic) has done i want a like(%) query which will give output 20 character from the selection suppose if i write a query SELECT * FROM Person WHERE description LIKE '%gov%' it will give the out put The govt has asked airlines to issue an all-inclusive and reasonable fares in a consumer-friendly manner, something that only Air India (domestic) has done what i want only 20 or 30 chracter from the like(%govt%) it can be any like character (%has%) or(%to%) it may vary but the o/p must be 20 or 30 character from the like(%) it should not contains all the charter the output must in this way .... govt has asked airlines to issue an all-inclusive and reasonable fares in a consumer-friendly manner -- View this message in context: http://old.nabble.com/like-operator-tp30423979p30423979.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users