Thanks to all. TRIM function is working fine.
On Tuesday, March 13, 2012 10:30:48 AM UTC+5:30, Durairaj wrote: > > Hi all, > > I have an array with the combination of alphanumerical and NULL values. > My requirement is avoid the the NULL values in this array. I have tried > with CONVERT function but it's not working. > Can anyone help me with this? > > For example: > > ARRAY.TEST = 'FX1000':@FM:'NULL':@FM:'FX2000':@FM:'NULL':@FM:'FX3000' > > > Thanks & Regards, > Durairaj. N > On Tuesday, March 13, 2012 10:30:48 AM UTC+5:30, Durairaj wrote: > > Hi all, > > I have an array with the combination of alphanumerical and NULL values. > My requirement is avoid the the NULL values in this array. I have tried > with CONVERT function but it's not working. > Can anyone help me with this? > > For example: > > ARRAY.TEST = 'FX1000':@FM:'NULL':@FM:'FX2000':@FM:'NULL':@FM:'FX3000' > > > Thanks & Regards, > Durairaj. N > On Tuesday, March 13, 2012 10:30:48 AM UTC+5:30, Durairaj wrote: > > Hi all, > > I have an array with the combination of alphanumerical and NULL values. > My requirement is avoid the the NULL values in this array. I have tried > with CONVERT function but it's not working. > Can anyone help me with this? > > For example: > > ARRAY.TEST = 'FX1000':@FM:'NULL':@FM:'FX2000':@FM:'NULL':@FM:'FX3000' > > > Thanks & Regards, > Durairaj. N > On Tuesday, March 13, 2012 10:30:48 AM UTC+5:30, Durairaj wrote: > > Hi all, > > I have an array with the combination of alphanumerical and NULL values. > My requirement is avoid the the NULL values in this array. I have tried > with CONVERT function but it's not working. > Can anyone help me with this? > > For example: > > ARRAY.TEST = 'FX1000':@FM:'NULL':@FM:'FX2000':@FM:'NULL':@FM:'FX3000' > > > Thanks & Regards, > Durairaj. N > On Tuesday, March 13, 2012 10:30:48 AM UTC+5:30, Durairaj wrote: > > Hi all, > > I have an array with the combination of alphanumerical and NULL values. > My requirement is avoid the the NULL values in this array. I have tried > with CONVERT function but it's not working. > Can anyone help me with this? > > For example: > > ARRAY.TEST = 'FX1000':@FM:'NULL':@FM:'FX2000':@FM:'NULL':@FM:'FX3000' > > > Thanks & Regards, > Durairaj. N > -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
