Member Avatar for jchandramouli
jchandramouli 0 Newbie Poster

Hi,

I got a table with datas that has alphanumeric values like :
1230-544,15C5487,132DE78.

Now i need to extract only integers fomr these datas and convert to bigint. The other characters have no impact in my query. Is there way to produce a data like that?

Thanks in advance.

Mouli

  • 1 Contributor
  • 0 Replies
  • 50 Views
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.