This is query am trying to execute, having problem with this § symbol. If this symbol is not present am getting the values correctly. But when I used this symbol records not getting correctly. I suppose not to ignore the symbol in this query.

SELECT DISTINCT a.area_code, t.trans_text AS Area_Name, a.area_sakey, 
+a.sort_order_num AS Area_Sort_Num FROM BL_trans t, pmon_cfg_fac pcf, 
+BL_station s, BL_equip e, BL_department d, BL_area a, BL_plant p, pmo
+n_cfg_fac_type pcft , bl_gen_row_col_value grcv WHERE a.area_sakey = 
+d.area_sakey AND d.department_sakey = e.department_sakey AND e.equip_
+sakey = s.equip_sakey AND s.station_sakey = pcf.station_sakey AND a.a
+rea_name_text_sakey = t.text_sakey AND a.plant_sakey = p.plant_sakey 
+AND p.plant_code = 'DAGEE' AND t.lang_code || NULL = '0X0409' AND pcf
+.facility_type_id = pcft.facility_type_id AND s.station_sakey=grcv.ge
+n_row_sakey AND grcv.gen_table_code='BL_STATION' AND grcv.appl_code='
+PMON' AND grcv.appl_col_code='SUPPLIER_ACCESS_LIST' AND (grcv.text_va
+lue like '%B43P §%' or grcv.text_value like '%CXM7A§%' or grcv.text_v
+alue like '%P73KA§%') AND pcft.qas_flag <> 'Y' ORDER BY a.sort_order_
+num, a.area_code

[download]

In reply to Re^2: When using § symbol am not getting any value by sudhakar1k
in thread When using § symbol am not getting any value by sudhakar1k

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.