Skip to main content
Discussion
Fathia JamaSemarchy Team
Sr. Customer Success Consultant at Semarchy

What is the purpose of SEM_TO_CHAR2, when should I use it and what is the differences between SEM_TO_CHAR2 and other conversion SemQL functions?

Where am I?

In Semarchy Community you can ask and answer questions and share your experience with others!

Peter Tse
Peter Tse Semarchy Team

Hi Fathia

SEM_TO_CHAR2 converts any datatype to string. It is a 'catch all' one.

If you know your specific datatype then you could use:

SEM_TO_CHAR which converts a number or string type to string.

SEM_NUMBER_TO_CHAR which converts a number type to string.

A full list of these can be found in the SemQL Reference Guide

Regards, Peter

Related Discussions