%META:TOPICPARENT{name="VirtTipsAndTricksGuide"}%

---+How to construct query to change all the values of properties in a triple to strings?

Suppose for given graph all values of properties are a mixture of strings and decimals. 

<verbatim>
SELECT DISTINCT ?sa ?oa 
FROM <http://ucb.com/nbeabase>
WHERE 
  { 
    ?sa a <http://ucb.com/nbeabase/resource/Batch> .
    ?sa <http://ucb.com/nbeabase/resource/chemAbsNo> ?oa . FILTER regex(?oa, '-','i')
  }
</verbatim>

In order to change the values to string, should be executed the following statement:

<verbatim>
SQL> SPARQL 
INSERT INTO GRAPH <http://ucb.com/nbeabase> 
  { 
    ?sa <http://ucb.com/nbeabase/resource/sampleId> `str (?oa)` 
  }  
WHERE 
  { 
    ?sa <http://ucb.com/nbeabase/resource/chemAbsNo> ?oa .  FILTER regex(?oa, '-','i')   
  }
</verbatim>



---+++Related
   
   * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]]
   * [[http://docs.openlinksw.com/virtuoso/rdfandsparql.html][RDF Data Access and Data Management]]