Slash sign interpreted as end of field

[Anonymous]

Hi, I'm pulling data from a SQL server db via OLEDB. In one table some fields have a /-sign (slash) in it. Now i suspect that while getting the data into QV those field values are truncated at the slashes. Current statement is simply: SQL SELECT FROM blah.dbo.blah. Any advice? Thanks, Sander

[beristardj · Accepted solution]

One suggest is, in select sentence can use functions for SQL, in this case, you can be use function replace().

select a, b, c from table

select a, replace(b,'/','x') as b_r, c from table

This functions works for the execution run in Server, not in QV.

im wait this stuff works for you, regads.

Saludos desde Mexico

[Anonymous]

Hi BeristarDJ, your tip to use the replace function helped me to 'restore' the value I need in this case. Still looking into a way to fully prevent the truncating at the slash in this setup. But fine for now. Regards, Sander