You should use something like:

if object_id('TABLE_NAME') is not null drop table TABLE_NAME.

Jorge.

Hi Khushbu,

Below is my answer to your problem, you should create a function, then you can make a max.

alter function dbo.token_char

(

@col1char(1),

@col2varchar(200)

)

RETURNS @tokens table (

col1 char(1),

col2 varchar(200)

)

as

begin

declare @var varchar(200)

set @var=replace(replace(replace(@col2,' ','.'),'-','.'),',','.')

while...