• Hi man,

    This is just a guess.

    using System;

    using System.Collections.Generic;

    using System.Linq;

    using System.Text;

    using System.Runtime.InteropServices;

    using System.ComponentModel;

    using System.Data.SqlTypes;

    namespace ConvertToASCII

    {

    public static class ConvertStringToASCII

    {

    public static string ConvertToASCII(int codePage, SqlString input)

    {

    string output;

    Encoding srcEncoding = Encoding.GetEncoding(codePage);

    byte[] byteInput = input.GetUnicodeBytes();

    byte[] byteOutput =ASCIIEncoding.Convert(srcEncoding, Encoding.ASCII, byteInput);

    output = Encoding.ASCII.GetString(byteOutput);

    return output;

    }

    }

    }