how do I get rid of the spaces at the

[sql norvis]

begining of a string in the Oracle database?

[susanta_nj]

You can use "trim()" function to do that. Look at Oracle SQL Manual to find out how to use trim() function. If you want to correct data in a table to get rid of leading spaces, use Update with trim function. Did a google search with "oracle trim function" and got lots of hits.

www.google.com