Database

DECLARE @FieldValue varchar(100);
SELECT @FieldValue = AffectedField FROM AffectedTable WHERE Key = @AffectedKey;

WITH E1(N) AS
(
    SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1
    UNION ALL SELECT 1 
    UNION ALL SELECT 1
    UNION ALL SELECT 1 
    UNION ALL SELECT 1 
    UNION ALL SELECT 1
    UNION ALL SELECT 1
),
cteNumbers (N) As
(
    SELECT
        ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) 
    FROM 
        E1 a, E1 b -- Cross-join = 100 rows
)
SELECT TOP(LEN(@FieldValue))
    N,
    Ascii(Substring(@FieldValue, N, 1)) As AsciiCode,
    Substring(@FieldValue, N, 1) As Character
FROM
    cteNumbers
ORDER BY
    N
;

Biplob Singha Shee wrote:

Can anybody help me ?

Biplob Singha Shee wrote:

Please read the entire question first

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

telnet 192.168.0.11 1234