How to create an Apply any function (SQL) Custom Value?

applying any function (sql) custom value allows you to write a query needed for your selection using any of the sfmc supported sql operators you can use the board freely allowing you to either code from scratch or copy paste existing queries applied in the select clause to generate new values as necessary important note only sql functions applied in the select clause work in case you copy queries with a from/where statement, or that require other statements after the select clause eg a group by, it won't work watch this video to learn more about applying any function (sql) custom value how to create an apply any function (sql) custom value? go to custom values section > add new value button provide a name for the custom value > apply formula to a field > click next > apply any function > click next select the type of value that you want to populate use the board to write your query optionally, you can use the suggested functions via the insert function dropdown > click insert formula once you found the operator you need the chosen formula including the parameters needed for it will be inserted on the board you will then just need to replace the parameters with actual fields or text use the insert field function to automatically add the chosen data extension and field to the board as part of the parameters if necessary choose the data extension and field > click insert field click check syntax to validate the query > click save drag and drop the new custom value to the target data extension fields scenario you want to get the first name of your contacts in camel case for your email campaign in order to achieve that, you want to convert only the first character of each record to uppercase, and the rest to lowercase follow these https //support deselect com/hc/en us/articles/360017044678 to achieve this you can also create reusable custom values follow this link to learn https //support deselect com/hc/en us/search/click?data=bah7djohawrskwgrqi9%2fjgo6d2fjy291bnrfawrpa8uyktojdhlwzukidgfydgljbgugogzfvdoidxjsssjxahr0chm6ly9zdxbwb3j0lmrlc2vszwn0lmnvbs9oyy9lbi11cy9hcnrpy2xlcy8xmte2mdq1odg2nte2os1dyw4tss1yzxvzzs1tes1ddxn0b20tvmfsdwvzlwlulwfues1tzwxly3rpb24tbjsivdooc2vhcmnox2lkssipzjhlmdrhzwityjk3ns00zjm1lwfiytgtytm5mtk4ngfkmdnhbjsirjojcmfua2kgogtsb2nhbgvjigplbi11cwy7cfq6cnf1zxj5ssiry3vzdg9tihzhbhvlbjsivdoscmvzdwx0c19jb3vudglb 8d89b0696ecc8e9fbc9296d7434db1983a4f6f07