Replace issue

[Nagaraj6]

Hello All,

I need a help

I getting wrong output  below,ending with -from-

I need concatenate Destination and From city name.

expected output ex: andaman-and-nicobar-from-pune

I am using this formula I getting syntax error

if(Des='',if(From<>'',lower(Replace(Des&'-from-'&From), '-from-', '', 2),lower(Des)),'') as [Des-From],

[edwin]

you can try a few things, try using isnull(Des) and for From or use len(Des)=0
sometimes using the test against 0 len string does not work depending on the data

[anat]

Can you try to eliminate the records while load where From field is null

[Chanty4u]

Try this 

if(From<>'',

    lower(Replace(Des&'-from-'&From, '-from-', ''), '-') as [Des-From]

)