Thnaks for ur reply.

Yeah I know I can do it in SSMS but I cannot import or export packages by connecting to integration services, coz I am encountered with an...

Thanks Chris

Hello chris,

this is a part of my function

CREATE function [dbo].[PostcodeValidation](@Country NVARCHAR(100),@Addressline NVARCHAR(100))

RETURNS VARCHAR(10)

AS

BEGIN

DECLARE @Result varchar(10)

IF @COUNTRY IN ('Afghanistan','Albania','Angola','Antarctica','Antigua And Barbuda','Aruba','Bahamas','Belize','Bhutan','Botswana',

'Burkina Faso','Burundi','Cameroon','Central African Republic','Comoros','Cook Islands','Cote DIvoire','Democratic Peoples Republic Of Korea',

'Democratic...

Thank you steve. I'll try it

Thanks for reply, but dtexec and dtexecui are giving the same error

Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Fuzzy Lookup"...

Is there any way in standard edition to execute this package other than executing in bids?

Sorry bear with me:-).

I got to clean my city data in TableA based on the similarities and confidences, want to use fuzzy match so that can clean any...

Yeah Sure Paul

Suppose my tableA conatins Values like

insert tableA

(city)

values ('Pleasanton'),

('Ven');

My reference TableB contains values like

insert @TableB

(input_city,output_city)

values ('LEA' 'Albert Lea'),

(PLEASANTON','Pleasanton')

('VEN',Belgium)

('ZAVENTUM',Zaventum);

then our update statement might update city Pleasanton with output_city Albert...

The wildcard solution i tried before is not working in the way I want.

So switched to Charindex.

I am nearly there.

Select * from tablea

where exists

(Select * from tableb where...

Thanks for the reply.

Actually my reference table contains 2 million records. So I dont want to use join now as it is giving inappropriate results.

I tried something like this

Select *...

Sure Paul I will from next time.

I'll have a try on the solution u provide.

Thanks a lot.

My final table TableA shoulb be like this

TableA

City

-----

London

London

London

London

Chicago

Chicago

Thanks for the reply.

I have tied that,

but the thing is I dont have any idea of framing my condition, which need % with column name

SORRY Small change

On a whole something like this

when city LIKE %input_city

then set city = output_city.

when city LIKE %input_city%

then set city = output_city

when city LIKE input_city%

then set city = output_city.

Thanks a lot Vani.

Your Solutions is really working and helped me.

Thanks a lot again