Thanks for help, could you please write some more in details, how can we supply login I'd and password to network drive, do you mean while mapping it? Please provide...

May be this solves my problem if it is correct way - (Performance wise/logic wise)?

select max(Case when lastLogon is null then addedDatetime else lastLogon end) as LastLogin,

datediff(d,...

These processes would not be making it UI slower at the time of typing text? I am also concerned about the performance on each key press, back space key punch...

Thanks, this is what I was looking for. I used this technique atleast 10 years ago with SQL server 2000 but forgot these steps. I will try it on Monday...

As i mentioned earlier in detail that Windows authentication is not working.

Shamshad Ali

i used following to fix my requirement

select id, Name, dt1, convert(varchar, GetDate(), 107) from (

select id, Name, convert(datetime,dt) as dt1 from mTable1 WHERE case when (isdate (DT) = 1)...

Think positive, I am using this code and for explaining my problem I wrote it as it is. so that others can understand what is my question. Try to help...

I am NOT concerned with PatIndex issue, I just used the sample code here for everyone to understand how I am looking for search using this piece of code which...

Thanks, can we do this in SSRS 2005?

Shamshad Ali

SELECT * FROM tbl_user

WHERE UserName LIKE '%[^a-z0-9 ._-]%'

This gives me the result of all those specail characters like $ and hyphen and so on. Its fine. Thanks, Thanks...

I need to list them down. if there is a way. also how should i exclude space" " and dot"." from [a-z0-9]

Thanks all for help...

Shamshad Ali.

the problem exists with NTLogin, that accept all characters except few. That is what i wanted to tell programmer that he must care of those all and the queries must...

Thanks for your reply, but this really does not help me. also the link u sent is not accessible. Plz. verify.

The problem is I have to "Find DISTINCT SPECIAL characters...