how to insert special character in sql database like wise" @#$%^&&*"
plz mail me ans at salman_hundekar@rediff.com
salman_hundekar 0 Newbie Poster
Mitja Bonca 557 Nearly a Posting Maven
Specify them as string and use @ simbol infront of the variable - so the string will be take exactly as it is - no escape characters will be used and add 2 quotations marks on the end to use last quote in the string:
Dim myChars As String = "@#$%^&&*"""
salman_hundekar 0 Newbie Poster
but i want to enter data in form of " 0493CH000P&T "
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.