How to take the first letter and insert it in another field

Databases
21

Now if i want to use this code it is giving error, please need your attention with this dear guys

DELETE * fromTABLE WHERE catid !=‘40’

because i want to delete all records except who have catid 40

With thanks

22

what is the exact error you got?

23

No errors, just i have a category want to keep it:)

24

didn’t you just say “Now if i want to use this code it is giving error” ???

25

Think it is an english mixup Rudy. Think he meant will it give one or what would happen if i ran it.

26

Yes the Delete * From, but now i corrected that to delete from tbl:)