question

Kheny avatar image
Kheny asked

Hi, I have table to find out Delimiters (,^ n |) for multiple tables in teradata and output should be as is.

Hi, I have table to find out Delimiters (,^ n |) for multiple tables in teradata and output should be as is. I have used like operator to find but i should repeat the same with multiple tables. It is consuming lots of time. Can anyone suggest me what changes i can do here@tim please help me!!

sqlteam
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Below is the example

Col1- Id is 123 Name address

Col2- Name is mona

Col3- Address is #13,Jainroad|Mh

Here i have to find commas and pipeline in address column Similarly i have to apply on different columns

Select * from table Where col1 like '%,%';

0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.