what does ^{single box} here mean ? thx.

Matt:

select count(*) from adjustment t2...

I think you mean sql 2000 sp4.

http://www.microsoft.com/downloads/details.aspx?familyid=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en

According to above link

Important: SQL Server 2000 Service Pack 4 is not supported on Windows NT 4.0, Windows Millennium Edition and...

I did the change with real pass word. it still did not work. I am wondering what is wrong. See it will set up in the sql server. most of...

skrilla99 (12/10/2007)

---

Perhaps the easiest thing to do is to make the change you want in Management Studio but don't click save. Then click the button at the far left...

why do post your asp.net code or sql code ?

I do not think I can set up in asp.net data control datasource for datasource like that. I am hoping I can find the one line code for that.

Thx.

I am not quite understand why you said.

Since the statement will use in the asp.net detail view data source. I have no way to set variable there.

It use data bound....

Thx. It worked fine right now.

It is vb.net code , here.

in the vb.net

I have select statement

select EMPLNO,[Full Name],[CCNAME],[CC] from HREMP where [Full Name] like '%" & REPLACE(strS,'''','''''') & "%' and [CC] like '01032%' and (EMPSTATUS...

but the outcome did not come out as I expected.

select EMPLNO,[Full Name],[CCNAME],[CC] from HREMP where [Full Name] like '%O''CONNELL%' and [CC] like '01032%' and (EMPSTATUS <> 90 or EMPSTATUS is...

I tried that before. While I bulit the vb.net application. it gave me error.

strS=Replace(strS,'''',''""")

it has bulit error. expression expression expected.

if I put strS with replace in my string like...

Thx.

Thx. That is not easy place to locate.

Matt:

Thx. Just curious in SQLServerCentral.com how can you locate the link ?