column value

samba · Post by **samba** » Mon May 22, 2006 11:31 am

i have routine that routine is generating two columns

i need to get where columnname = starting with "link...."
how to get particular rows

can any one please help me

DSguru2B · Post by **DSguru2B** » Mon May 22, 2006 11:38 am

you can use the following in the sql

Code: Select all

where LEFT(columnname,4) = 'link'
or
where columnname like 'link%'

samba · Post by **samba** » Mon May 22, 2006 11:54 am

i have the data in flat file not in DB

samba · Post by **samba** » Mon May 22, 2006 11:54 am

i have the data in flat file not in DB

DSguru2B · Post by **DSguru2B** » Mon May 22, 2006 11:57 am

if px has matches, search the forum for Matches, that will get you your solution.

kris007 · Post by **kris007** » Mon May 22, 2006 12:35 pm

I think even LEFT function works out good, even if your data is in flatfile.
Just a thought.

samba · Post by **samba** » Mon May 22, 2006 12:40 pm

Yes its working

Thanks