• This would do the same:

    SELECT

    TOP 100

    comp_id, sup_code, sup_name, sup_ac_code, '0a1705011715553107773972'

    FROM

    comp_ac

    ORDER BY

    comp_id

    It does not seem to make any sense to supply a parameter value to a query to get exactly the same value back.

    There must be something missing from your description.

    _____________
    Code for TallyGenerator