Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a function that I can use in the loads script that I can us in the load script that will tidy up my data in a field.
e.g
proper(FirstName) as FirstName
therefore a name that is like gAVin returns back as Gavin
I am aware of the upper function
Try using the Capitalize() function - this will capitalize the first letter of every word, which is what you'd want for things like names and titles.
Try using the Capitalize() function - this will capitalize the first letter of every word, which is what you'd want for things like names and titles.
How can i capitalize only the first letter of the first word?