Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on Windows NT 5.1...

Yes I tried in Enter prise manager

I insert this

INSERT INTO TESTTBL(MYID, MSG)

VALUES (1, 110)

it works fine!!!

Thankx for the comments. Which help me a lot.

This my first article in this forum. from a single article I learnt a lot

Thankx every body.

I accept UR opininon

But the question is whether to have index on this type of field.

Say,Are we going to add an index to Qty field

Ok thanks every body

in SQL View

I want to run this query

Select * from Table1

-- Where a= 1

Where a= 1 is the commented line

http://www.devx.com/tips/Tip/17668

Thank You Both guys

Yes Bcos We are saving multi bite charctors

So we need field to be in nvarchar

Do u know any similar function for access

Great!!!

My field is nvarchar

Select [Description]

From alarmLogic

where

Convert(Binary,Convert(varchar, [Description]))= Convert(Binary, 'below')

is working for me

Thankx

Actully solution should be valid for any no of charators

'a' is an example it can have more charactors

User is entering the value which he want to select

depending on that value...

CREATE PROCEDURE [dbo].[FindANDReplaceString]

@Tablename varchar(20),

@FieldName varchar(20),

@FindString varchar(30),

@RepalceString varchar(30)

AS

/*'Select * From Tablename*/

declare @sqlstring varchar(8000)

Select @sqlstring = "Update " + @Tablename + " Set " +...

CREATE PROCEDURE [dbo].[FindANDReplaceString]

@Tablename varchar(20),

@FieldName varchar(20),

@FindString varchar(30),

@RepalceString varchar(30)

AS

/*'Select * From Tablename*/

Update @Tablename Set @FieldName = Replace(@FieldName,@FindString,@RepalceString)

GO

Above SP @Tablename ,@FieldName are in correct.Can any body...