Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
searching fields with spaces in them
James, thank you! isn't it easy when you knoe how. Nick- cwizard
- Post #3
- Forum: Microsoft SQL Server: Programming
-
searching fields with spaces in them
I have a data base of postcodes, stored with spaces in them (LL29 6AF), my users often miss the spaces out. Can I use somthing like (this does not work!) Select address from postcodes where replace(postcode," ","") = [supplied postcode] Or is there a simple way of removing the spaces from the...- cwizard
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
How can I check if another server is running from my site
I am trying to build a server monitor on a shared NT4 server with ASP. I am NOT allowed to register DLL's on the server, so.. I have tried the FSO object to Open a file on the remote server (for read), I have also tried FileExists. It does not work (won't access files on another server?). I have...- cwizard
- Thread
- Replies: 1
- Forum: Microsoft: ASP (Active Server Pages)
