Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    6

    Unanswered: why does't my quary return any values

    why does't my quary return any values

    I wrote this quary and got an empty table in return:

    select * from prosjekt;
    PROSJEKTNR PROSJEKTNAVN BESKRIVELSE DATO PORTALNR
    ---------------------- --------------- --------------------------------------- ------- ----------------------
    1 prøve øyvind prøver 2004... 1
    2 horoskop sql spørring 2004... 1

    select beskrivelse from prosjekt where prosjektnavn='horoskop';
    BESKRIVELSE
    ---------------------------------------

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Try this to see what you get ... maybe a garbage character or space

    select beskrivelse from prosjekt where prosjektnavn like '%horoskop%';

    or

    select beskrivelse from prosjekt where upper(prosjektnavn)
    like '%HOROSKOP%';

    Gregg

  3. #3
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120

    Re: why does't my quary return any values

    Originally posted by oyvim
    why does't my quary return any values

    I wrote this quary and got an empty table in return:

    select * from prosjekt;
    PROSJEKTNR PROSJEKTNAVN BESKRIVELSE DATO PORTALNR
    ---------------------- --------------- --------------------------------------- ------- ----------------------
    1 prøve øyvind prøver 2004... 1
    2 horoskop sql spørring 2004... 1

    select beskrivelse from prosjekt where prosjektnavn='horoskop';
    BESKRIVELSE
    ---------------------------------------
    It actually looks like the value for beskrivelse in the second query is 'sql' according to the output from your first query.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •