vamsi_4a6 wrote:I have concatenated as mentioned below
Start,End,Start_End,End_Start,Distance
Bangalore,Mumbai,BangaloreMumbai,MumbaiBangalore,1500
Hyderabad,Delhi,HyderabadDelhi,DelhiHyderabad,2000
Delhi,Hyderabad,DelhiHyderabad,HyderabadDelhi,2000
Mumbai,Bangalore,MumbaiBangalore,BangaloreMumbai,1500
How to use above Start_End,End_Start columns for comparisions?
Hi,
Use the substring function to check whether the string exist in the column.
Regards
Naveen