Separate values in a column

[d_ankusha]

30232530,74121110 is the value I have in a column. i want these values separately in two different rows. can anyone please give me query to separate these values?

[sunny_talwar · Accepted solution]

May be using SubField() function

SubField(FieldName, ',') as FieldName

[arvind_patil]

Hi Ankusha,

You will get data from subfield function.

SubField(FieldName, ',') as FieldName

Thanks,

Arvind Patil