how much of an impact would it be to change the column to big_int?

if there's an application that consumes the data, that would need to change to use int64,...

ok, then if you were searching email addresses for example, and you want to find items with teh @ symbol,then it's like this:

DECLARE @var varchar(10)

SET @var ='%' + '@'...

There's no such thing as just [@] in SQL....

i missed that the question was how to clean them as well as how to find them, thanks!

here's one way: a scalar function that strips out the non-compliant characters:

I've got the same functionality as a CLR, which uses Regular Expressions, but I've never tested which performs better.

SELECT...

well until you provide concrete details we've asked for for 3 forum pages so far, none of...

lol . if it doesn't matter, well...whatever.

I'll ask again for some specific code: show us what you've...

you'll have to join the table agaisnt itself wiht an alias:

something like this:

select * from product_to_cat t1

left outer join product_to_cat t2

on t1.product-id = t2.product_id

where t1.cat_id = 69

and t2.catid = 30

cuteprabakar...

i didn't even read your reply.

you have got to do your part first.

help us help you!

1. provide a CREATE TABLE example representative of what you are using.

2. provide INSERT...

well entire books have been written on indexing and improving performance;

i think you'll need to read up via a google search first, and come back with specific questions.

hbtkp (4/11/2012)

this is select statement in my sp,

i need to supply one parameter @name

this contains 2 item suppose pen and pencil,

and it gives me that 2 item ,

now in table...

i read your post twice, and I cannot visualize it;

is this your what your data would look like?

CREATE TABLE [dbo].[MYTABLE] (

VARCHAR(10) ...

sheesh Sean; now that YOU did...

my example is close by using FORXML, but i don't get the "ending/last" airport.

and my code example:

;WITH flight_tran_table (flight_tran_id , [(Other Tran Data)])

AS

(

SELECT 1234, '(Other Tran Data)'

),

flight_sectors_table(tran_id,sector_id,dept,arrive)

AS

(

SELECT 1234,1,'MAN','LHR' UNION ALL

SELECT...

i've linked...