1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Issue with SQLCE query

Discussion in 'C#' started by imported_anoop4real, Aug 31, 2010.

  1. imported_anoop4real

    imported_anoop4real New Member

    Aug 31, 2010
    Likes Received:
    Trophy Points:

    I have an sqlce query where I dynamically constructs the string by appending different strings. I have a field where I append a product name and its subname. Say for example
    main name "Pepsi" and Subname "Large", there are some instance where the Subname is empty and the subname value comes as "null". So when I append the string it will be say

    "Pepsi+null" ideally the result should be Pepsi but the sqlce interprets it as "null" and hence my query fails. My data comes from Orcale DB which doesnt support "null", hence even if I want the value as empty, Oracle will return me only null. Any idea why this is happening ? or is there is any solution.

    Hope I havent confused you guys!!


Share This Page