Hello again! Here I found a very nice solution with regex! public bool IsValidIPAddress(string ipAddr) { string pattern = @"^([1-9]|[1-9][0-9]|1[0-9][0-9]|2[0-4][0-9]|25[0-5])(\.([0-9]|[1-9][0-9]|1[0-9][0-9]|2[0-4][0-9]|25[0-5])){3}$"; Regex reg = new Regex(pattern, RegexOptions.Singleline | RegexOptions.ExplicitCapture); return reg.IsMatch(ipAddr); } http://blog.devstone.com/Aaron/archive/2006/03/29/222.aspx[^] All the best, Martin

Currently there is no such method to copy the constraints from the source to target table during table creation. For applying the constraints you must Alter the table. _____________________________ Success is not something to wait for, its something to work for.

Why don't you read the documentation: * SET QUOTED_IDENTFIER[^] * SET ANSI_NULLS[^] Scottish Developers upcoming sessions include: .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy My: Website | Blog

Hi, I hope that there is no option such as setcount on in sql, Instead we have a statement set nocount on/Off The explanation is given below which is available in SQL books online please refer the same for further explanation Stops the message indicating the number of rows affected by a Transact-SQL statement from being returned as part of the results. Syntax SET NOCOUNT { ON | OFF } Remarks When SET NOCOUNT is ON, the count (indicating the number of rows affected by a Transact-SQL statement) is not returned. When SET NOCOUNT is OFF, the count is returned. The @@ROWCOUNT function is updated even when SET NOCOUNT is ON. SET NOCOUNT ON eliminates the sending of DONE_IN_PROC messages to the client for each statement in a stored procedure. When using the utilities provided with Microsoft® SQL Server™ to execute queries, the results prevent "nn rows affected" from being displayed at the end Transact-SQL statements such as SELECT, INSERT, UPDATE, and DELETE. For stored procedures that contain several statements that do not return much actual data, this can provide a significant performance boost because network traffic is greatly reduced. The setting of SET NOCOUNT is set at execute or run time and not at parse time. Happy Programming

just simple using SELECT query.... << >>

thanks mr. khan the method is really cool. vivek -- modified at 4:39 Monday 6th February, 2006