Conecting over the Internet for getting data from clients.

I want to connect over the internet to get data from clients.What would
be the easiest method and the most stable methos to do it

1.Use a Point to Point prtotcol from the client pc and then upload the
data to our sql server
2.Export the data from the clint pc in XML format and then Enter it in
our computer.
3.Have all clienst ftp the data in a dirctory and then upload the xml
files from the directory?

Thanking you in anticipation.Would love it if we could discuss and
distribute our thoughts on this.

AjayFTP seems like the obvious choice unless you need the data continuously
available online.

--
David Portas
SQL Server MVP
--

Concatenating fields

Hi,

there's a method to concatenate fields in a WHERE clause?

I've a parameter which represents a name and surname of a person; in the table I've two fields representing one the name and the other the surname. I'd like to do a "LIKE" comparison concatenating Name and Surname field and confronting with my parameter... Is it possible?

Yes, it's possible.

WHERE Name + ' ' + Surname LIKE @.param

This may be another option:

WHERE Name LIKE @.param OR Surname LIKE @.param

Jos

|||

Like this?

DECLARE @.NAMESTABLE (idint IDENTITY(1,1), Forenamevarchar(10), Surnamevarchar(10))DECLARE @.SEARCHNAMEvarchar(20)SET @.SEARCHNAME ='Mark Smith'INSERT @.NAMESVALUES ('Mark','Smith')SELECT *FROM @.NAMESWHERE Forename +' ' + Surname = @.SEARCHNAME

|||

Jos has the solution... Tnx