Any Programmers, out there ...
Topic started by Raghu (@ 217.158.120.226) on Wed Jul 24 11:15:17 .
All times in EST +10:30 for IST.
Hello all;
I am an TSQL/VB6 programmer, I work as a database developer, I would like to know few programmers, so that we can help each others out, I would be much obliged & grateful,if anyone would help me.
thanks
q)I have the following table in SQL server 7
Create table employee
( empid int not null,
empname char(25),
empadd1 char(50),
......
)
The field empname has the following values
Jhon smith
Jhon crawley
Jhon blah blah
I want to replace the string "jhon" (just that bit) with John, without changing the rest of the characters in empname field.
replace function like
select replace ('empname','Jhon',John')
does not work as it replaces the whole string in the field.
should I decalare empname as variable of character type or use textptr to do this ?
many thanks
Responses:
- From: X (@ 128.241.245.34)
on: Wed Jul 24 14:04:04
I will give you a wonderful link. I am a vb6 programmer and I am sure this is a wonderful site you must visit.
- From: X (@ 128.241.245.34)
on: Wed Jul 24 14:05:33
Sorry the url is
http://www.visualbasicforum.com
- From: GV (@ london-hse-ppp3540982.sympatico.ca)
on: Wed Jul 24 18:01:34
"Any Programmers, out there ..." - Is this the name of a new Indian movie??
The name of this forum is "Indian Films Forum - For discussions on indian movies and music"
Why don't you move this to the "Miscellaneous" section?
- From: Milton (@ 203.116.61.131)
on: Wed Jul 24 22:49:28
Raghu,
update employee set empname='john' || substr(empname,5,length(empname)-4) where substr(empname,1,4)='jhon';
- From: Raghu (@ 217.158.120.226)
on: Thu Jul 25 06:34:46
x;
thangs 4 the info!
- From: Vithuran Balakrishnan (@ xs195-241-183-22.dial.tiscali.nl)
on: Sun Dec 7 12:11:43
Hi....
Are you looking voor computer programmer's!
I am a c++ programmer and I need a freelance job!
so please mail me if that is the meaning of this thread!
plz
Thnx
Tell your friend about this topic
Want to post a response?
Back to the Forum