ASP.NET

Spurple wrote:

Im trying to read word document located at client machine in asp.net 1.1

nikhil1234 wrote:

plz tell me sql

nikhil1234 wrote:

select name from names where name like '%jhone lee%' correct result
select name from names where name like '%lee jhone %' correct result
plz tell me sql

select name from names where name like 'jhone %'

DECLARE @Delimitedtext varchar(max);
DECLARE @Delimiter char(1);
SET @Delimitedtext = 'Manas Bhardwaj';
SET @Delimiter = ' ';

DECLARE @FName nvarchar(max)
DECLARE @LName nvarchar(max)


SELECT
@FName = SUBSTRING(@Delimitedtext,1, CHARINDEX(@Delimiter, @Delimitedtext)-1),
@LName = SUBSTRING(@Delimitedtext,CHARINDEX(@Delimiter, @Delimitedtext)+1, len(@Delimitedtext))

Select 
	[name] 
from 
	names 
where 
	[name] like '%' + @FName + '%'
	or
	[name] like '%' + @LName  + '%'

Liqz wrote:

Worked a treat, thanks

Liqz wrote:

I'm a forum noob as well as a programming noob!

Abhijit Jana wrote:

Then you should marked that post as Good Answer