Page 1 of 1
column value
Posted: Mon May 22, 2006 11:31 am
by samba
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
Posted: Mon May 22, 2006 11:38 am
by DSguru2B
you can use the following in the sql
Code: Select all
where LEFT(columnname,4) = 'link'
or
where columnname like 'link%'
Posted: Mon May 22, 2006 11:54 am
by samba
i have the data in flat file not in DB
Posted: Mon May 22, 2006 11:54 am
by samba
i have the data in flat file not in DB
Posted: Mon May 22, 2006 11:57 am
by DSguru2B
if px has matches, search the forum for Matches, that will get you your solution.
Posted: Mon May 22, 2006 12:35 pm
by kris007
I think even LEFT function works out good, even if your data is in flatfile.
Just a thought.
Posted: Mon May 22, 2006 12:40 pm
by samba
Yes its working
Thanks