On Thu, 9 Dec 2010 23:23:37 -0800 (PST), salmaan <sallu....@gmail.com> wrote:
>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 output > >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 This example does not match your requirement. It's over 100 characters, not 20 to 30. According your requirement, it would be 'govt has asked airlines to is...' This is best done in the host language, you can get the offset of the LIKE term with the charindex() or pos() function and cut off the string with the substr() function. The scope of sqlite is data and set operations, the scope of the host language is processing and presentation. SQLite does offer substr(), but not charindex(). There are sqlite extension libraries which do support extra functions, for example: http://www.mail-archive.com/sqlite-users@sqlite.org/msg21791.html (download the zip file and have a look at source file func_exp.c) -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
