vendredi 20 mars 2015

How to add spaces in selected records in SQLite?

I am making a windows forms application. In a report, I need the following output.



Name Total_Weight ....
Employee1 1000 ....
-Gold 500 ....
-Silver 500 ....
Employee2 2500 ....
-Gold 1000 ....
-Silver 1500 ....


So far I have achieved as below...



Employee1
Gold
Silver


So the question is how to add space in selected records? As you cans see in second result, I want to add two spaces and - in beginning of the word. I am using SQLite database and front end is C#.


Aucun commentaire:

Enregistrer un commentaire